HOW TO: Merge Office Address Book Contacts to Labels in Word X for Mac (321998)

SUMMARY

This article explains how to merge Office Address Book contacts to Avery labels in Word X for Mac.

MORE INFORMATION

Create a Data Merge by Using the Office Address Book

1. Start Word X for Mac, and then open a new blank document.
2. On the Tools menu, click Data Merge Manager.
   
   The Data Merge Manager appears to the right of the document on the screen.
3. In the Data Merge Manager, click Create under Main Document, and then click Labels.
4. In the Label Options dialog box, select the Avery label product number that you are using, and then click OK.
5. In the Data Merge Manager, click Get Data under Data Source, and then click Office Address Book.
6. In the Edit Labels dialog box, click the down-arrow in the Insert Merge Field list, and then insert the fields in the exact form that you want to use in the labels. Make sure that you insert any necessary spaces or punctuation.
   
   For example:

   Full_Name
   Address
   Country

   -or-

   First_Name Last_Name
   Street
   City, State_or_Province Zip_Code
   Country

7. After you have completed inserting the merge fields, click OK.
8. To preview the addresses and verify that everything appears as you want it to, click the arrow next to Preview, and then click View Merged Data.
9. If everything appears as you want it to, proceed to the next step. Or, you can modify the format of the labels or add and remove fields, as follows:
   1. To add Merge or Word fields, drag the Merge or Word fields from the Data Merge Manager into the first cell of the table (the upper-left label).
   2. When you have completed your modifications of the first cell in the table, click Propagate Label document under Data Source to adjust the remaining labels according to your changes.
10. In the Data Merge Manager, click Merge to New Document under Merge to complete the merge process.
    
    After the merge is completed, you are presented with a new document that contains your labels. You can edit, print, and save this document for future use if you want.

back to the top