This is how to print an envelope using Microsoft Excel. To do this, you will need Microsoft Word and Excel. This technique should be used regardless of whether the Microsoft Suite is installed on a Windows or Mac computer.
Step 1: Start your mailing list
It is important to start by creating a list for recipients. This step is optional if you are only printing one or two mailing envelopes. For large mailing lists, however, you will need to complete this step.
For more information on creating your mailing list, click her:
Open Microsoft Excel.
A new spreadsheet should be created with the following columns. First name, surname, address, state, country, postal code. You can import your contacts into the spreadsheet and add this information to the appropriate columns. The master mailing list will be created from this file.
This step allows you to confirm your address and avoid printing incorrect or obsolete data.
Step 2: Create your envelope
The next step is to create your Microsoft Word envelope template. You will use this document to automatically populate your recipients’ addresses with the automatic printing.
To do so:
Microsoft Word allows you to open a new blank document.
Select the Mailings tab.
Click Envelopes.
You will now need to specify the size of paper you want for your envelopes. Click the button below to proceed Preview icon.
In the Envelope Options Click tab and select the dropdown menu Envelope size.
You can choose the appropriate size for your envelopes. While Word can handle most of the common sizes of envelopes, you have the option to design your own Custom Size.
Next, select Font… The next is the Delivery address Box or Return address You can choose the font that you prefer for each option.
Select OK.
If you wish, the last step will be to add branding and other custom elements. To do so, click Add to document. . It will then open the envelope in Word. You can edit it like you normally would.
Note: A sample address can be used in the delivery address box to preview how your envelope will appear when printed. To preview your envelope, click Preview Results In the ribbon.
Step 3: Configure the printer feed
Tell Microsoft Word is the next step How your printer’s feed works . . This guarantees that envelopes are printed accurately and have all the elements organized correctly.
You can set up the printer feed her:
Click Mailings >> Envelopes.
Select Options.
Click the Printing Options tab.
In the Feed methodSelect the orientation of the envelope that will be fed into your printer from the window. It is best to position your envelope so that it borders the edge on the tray. This will allow you to insert the envelope into the printer more easily. If your envelope is not correctly placed, the return and delivery addresses may be incorrect.
Select Face up or Face down You can determine the direction in which you load your envelope.
Click Clockwise rotation You can rotate the envelope to suit your preferences.
You can click on the drop-down to see if you printer has more than 1 feed tray Feed from To choose the best tra.
Step 4: Begin the mail merge and link your mailing list
Now it’s time for mail merging. Microsoft Word will automatically merge the addresses and names from your address data source.
To do so:
Click here to download Word Mailings > Start Mail Merge > Envelopes.
Click the Envelope Options tab. Verify your settings carefully in the Envelope Options in the dialogue box, and then add your Return Address. After you have completed the setup, click OK.
Click File >> Save Save your template for an envelop.
Click Mailings > Select Recipients >> Use an Existing List. Type a New List. distribution list, Choose from Outlook Contacts.
Select your Microsoft Excel spreadsheetconfirm your decisio.
You have the option to select which addresses you wish to change Edit Recipient List To change them.
Click Address Block The ribbon. This will display how the address block looks with all your data. You will see a number of choices for printing your name and address on the left.
Select an option and then choose OK.
Step 5: Print your Envelopes
Once everything is in order, you can start the mail merge. To do so:
Select Finish & Merge, then Print Documents…
Make sure that you have selected “All”, and then check it again OK.
Check that the settings of your printer are correct and that you have correctly aligned envelopes before selecting OK again. Now, your printer will begin to print the envelopes.
Note: You can also use Word to communicate with others Print and create labels You can print directly on the envelopes with a printer, but prefer mailing labels. By clicking, you can edit the dialog box for address labels Mailing >> Labels. use mail merge You can create many labels.
Stamps don’t go unnoticed
Unfortunately, you can’t print envelopes using Excel alone. However, you can combine MS Word with Excel to print envelopes Excel, It is very easy to print envelopes. You should be able to print your next batch of mail in no more than a few minutes after reading this tutorial. Remember to add postage costs!