Microsoft Word 2008

Mail Merge: Creating Merged Mailing Labels

Mail Merge allows you to set up mailing labels that use the same format with information from a variety of records. Using data from a table or external database, you can print one label with different information for each record in the database or table. The following instructions describe how to merge a pre-existing database's values into address labels with the Mail 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 Mail Merge Manager
The Mail Merge Manager palette appears.
In the Select Document Type section, from the Create New pull-down menu, select Labels...
The Label Options dialog box appears.
From the Label products pull-down menu, select the brand name of your labels
NOTE: The most common brand is Avery standard.
From the Product number scroll box, select the product number of your labels
NOTE: The most common is 5160-Address.
Click OK
In the Select Recipients List section, from the Get List pull-down menu, select Open Data Source...
The Choose a Data file dialog box appears.
Navigate to and select the appropriate file
Click OPEN
The Edit Labels dialog box appears.
Using the Insert Merge Field pull-down menu, select the desired fields
Click OK
In the Preview Results section, click VIEW MERGED DATA
OPTIONAL: To preview your document with other recipients' information, in the Preview Results section, click the arrows
To finish and print letters
1. In the Complete Merge section, from the pull-down menu, select the appropriate option to designate which records to finish
2. Click MERGE TO PRINTER
  OR
  Click MERGE TO DOCUMENT