You can also use the other commands in the Preview Results group to find recipients or navigate through the addresses.To Preview what it will look like, click on the “Preview Results” command.Position the address block where you want it on the envelope by adding carriage returns, center alignment, etc.On the Mailings tab click on the Address Block command to add an address block.Next you can insert the address block into your envelope and preview the results The Word document is now connected to the Table in Excel.Īdding the Address Block and Previewing Envelopes Select the Defined Name, “Addresses” in the Select Table dialog and click OK.Select your address file in the Select Data Source dialog and click Open.Select the Use Existing List command from the Select Recipients Dropdown.Select the appropriate Envelope size and click OK.On the Mailings tab, select the Start Mail Merge / Envelopes Command.
#MICROSOFT WORD 5X7 ENVELOPE TEMPLATE HOW TO#
The remaining steps will show how to create the mail merge in Word to create envelopes. The steps above created a workbook containing a table of addresses on one sheet that has a name (Addresses) defined that corresponds to the table range.
#MICROSOFT WORD 5X7 ENVELOPE TEMPLATE UPDATE#
When a name is defined for a Table in a worksheet, the name will update automatically as the table is resized to add or remove data.
A dialog will appear asking for the range of cells containing your addresses and whether your table has headers.On the Insert Tab, click on the Table button.Select a cell within the range containing the addresses, such as cell B2.The first step is to create a Table from the list of addresses.