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

Article translations Article translations
Article ID: 321998 - View products that this article applies to.
This article was previously published under Q321998
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

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.

Properties

Article ID: 321998 - Last Review: October 24, 2013 - Revision: 1.2
APPLIES TO
  • Microsoft Word X for Mac
Keywords: 
kbnosurvey kbarchive kbhowto kbhowtomaster KB321998

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com