Use Mail Merge to automatically add mailing addresses or other personalized information to your publications.

  1. On the Mailings tab, click Mail Merge > Step-by-Step Mail Merge Wizard.

  2. In the Mail Merge pane, under Create recipient list, select one:

    • Use an existing list.

    • Select from Outlook contacts.

    • Type a new list.

  3. Click Next: Create or connect to a recipient list.

  4. Your recipient list options depend on the choice you made in step 2:

    • To use an existing recipient list, select the list in the Select Data Source dialog box.

    • To select from your Outlook contacts, select the contacts list in the Select Contacts dialog box, and click OK. Then, select individual recipients in the Mail Merge Recipients dialog box, and click OK.

    • To create a new list, in the New Address List dialog box, type the names, addresses, and other details for your recipients, and then click OK.

      Note: Before you begin typing information in your new list, you can add, remove, or rename fields that appear in the New Address List dialog box. Click Customize Columns, and then make your changes.

      When you are done adding recipient details, give your list a name, and then click OK.

  5. Click Next: Prepare your publication.

  6. Prepare your publication by dragging recipient information items (such as name and address) onto your publication.

  7. Click Next: Create merged publications.

  8. Under Create merged publications, select one of the following:

    • Print to print the merged pages.

    • Print preview to view the pages before you print them.

    • Merge to a new publication to create a new publication with the merged pages.

    • Add to existing publication to add the merged pages to the end of your publication.

    You can also choose to print your recipient list, save a shortcut to the list, or export the list to a new file.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!