Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Use Outlook contacts as a data source for a mail merge

Your Outlook contact list can be the source of personalized information in a batch of Word documents, through Word's mail merge feature.

  1. In Outlook, go to Contacts, and select the names you want to include. Or, if you want to include the whole address book, skip this step.

  2. Go to Home > Mail Merge.

    The Mail Merge button is on the Home tab in the Actions group

  3. Choose the options you want, and then select OK.

    Click Mail Merge on the Home tab of the Contacts folder to start a mail merge

    Note: If you've selected a set of contacts that you'll want to use again without choosing them each time, select Permanent file and give the list a name.

  4. In Word, on the Mailings tab, insert mail merge fields that pull information from the Outlook contacts list into your document.

    Tip: The merge field Address Block is perfect for envelopes and labels; Greeting Line works great for personalizing letters and email.

  5. Add any text that you want on each of the documents, envelopes, labels, or emails. For example, if you're sending a form letter, this is where you write the body of the letter.

  6. Choose Preview Results, and then choose Next Next record button for mail merge preview results or Previous Previous record button for mail merge preview results to see each personalized document, envelope, label, or email.

  7. To complete the merge, in the Finish group, choose Finish & Merge, and then choose Print Documents or Send E-mail Messages.

Reuse your mail merge

Save the merge document so that you can run it again without having to set anything up. The merge document stays connected to the data source.

When you want to run it again -- for example, another batch of envelopes to the same people -- go to File > Open in Word, and open the document. Choose Yes when Word prompts you to keep the connection.

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!