This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?
A popular use of the Mail Merge feature is to create mailing labels. The following instructions describe how to merge a pre-existing database's values into address labels with the Data Merge Manager .
Begin the process of creating mail merge labels by setting up your starting document. When creating labels, you have many options. You can choose the label size, text font, positioning of the information, etc. to suit the needs of your particular project.
From the Tools menu, select Data Merge Manager
The Data Merge Manager appears.
In the Main Document section, from Create pull-down list, select Labels...
The Label Options dialog box appears.
From the Label products pull-down list, select the type of label
NOTE: The most common is Avery standard.
From the Product number scroll box, select the model number
NOTE: The most common is 5160-Address.
Click OK
From the Data Merge Manager, in the Data Source section, from the Get Data pull-down list, select Open Data Source...
The Choose a File dialog box appears.
Locate and select the file you will use for your list
Click OPEN
The Edit Labels dialog box appears.
When the label is complete, click OK
To have the same information repeat for each record on the same sheet of labels, from the Data Merge Manager, in the Data Source section, click PROPAGATE LABEL DOCUMENT![]()
To preview your merged document, from the Data Merge Manager, in the Preview section, click VIEW MERGED DATA
NOTE: For more information on editing the recipients' information, refer to Working with the Data Source.
Click PRINT
Save the new document