Skip navigation

Topics Map > Office 365 > Word

Microsoft Word - Get to Know Mail Merge

When you communicate with customers through welcome letters, special announcements, thank you emails, or invoices, use mail merge to create personalized documents that get their attention.



Understand the mail merge process

The mail merge process involves three documents:

  • Your main document: This contains text and graphics that are identical for each version of the merged document. Examples of identical content include the return address on the envelope or the body of a letter.

  • Your mailing list: This contains the data that is used to fill in information in your main document. For example, your mailing list contains the addresses to be printed on the labels.

  • Your merged document: The combined main document and mailing list become the merged document. Information is pulled from your mailing list and inserted in duplicates of your main document, resulting in merged documents that are personalized for different people.

Consider mail merge possibilities

  • Letters: Create and print a batch of personalized letters for everyone on your mailing list. Each letter prints on a separate sheet of paper.

  • Email: Create and send email messages to each person on your mailing list.

  • Envelopes: Create and print a batch of envelopes for mailing.

  • Labels: Create and print sheets of mailing labels. Each label contains a unique mailing address.

Data sources

Word can pull data from a variety of data sources to perform mail merge. If you don't have a mailing list, create one during the mail merge process. Here are a few simple data source options:

  • Excel spreadsheet: Use an Excel spreadsheet, which works well as a data source for mail merge if all data is well-formatted and on one sheet.

  • Outlook Contacts list: Select recipients from your Outlook Contacts.

  • Word data file: Be sure that your Word document contains a single table. The first row of the table must contain headings, and the other rows must contain the records that you want to merge.

Want more?

Discover more courses like this at LinkedIn Learning

Use mail merge to create and send bulk mail, labels, and envelopes

Other data sources you can use as your mailing list

Prepare your Excel 2016 data source for a Word mail merge

Use mail merge to send bulk email messages


If you have any questions, come by the Help Desk at Hardman & Jacobs Undergraduate Learning Center Room 105, call 646-1840, or email us at help@nmsu.edu.




Keywords:microsoft word mail document merge office 365   Doc ID:79523
Owner:John B.Group:New Mexico State University
Created:2018-01-22 10:14 MDTUpdated:2018-05-23 14:55 MDT
Sites:New Mexico State University
Feedback:  0   0