Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×