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

This article was previously published under Q321998
This article has been archived. It is offered "as is" and will no longer be updated.
This article explains how to merge Office Address Book contacts to Avery labels in Word X for Mac.


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:
    First_Name Last_Name
    City, State_or_Province Zip_Code
  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
MacWDX Mac WDX macword

Article ID: 321998 - Last Review: 10/24/2013 11:41:16 - Revision: 1.2

Microsoft Word X for Mac

  • kbnosurvey kbarchive kbhowto kbhowtomaster KB321998