Topics Map > Office 365 > Word

Microsoft Word - Use and Excel Spreadsheet for Mail Merge Contacts

Personalize names, addresses, and much more in bulk email or documents. Any data stored in an Excel workbook can be used to personalize communications.



Note: These steps only cover what's shown in this video. For detailed steps on how to do a mail merge, please see Mail merge using an Excel spreadsheet.

Use an Excel spreadsheet for mail merge contacts

  1. Open the Word document that you want to mail merge.

  2. Select Mailings > Select Recipients.

  3. Select Use an Existing List.

  4. Select the Excel spreadheet you want to use, and select Open.

  5. Select the worksheet that you want to use, and select OK.

    Each worksheet name ends with $.

  6. Select Edit Recipient List to view the data source, select the checkboxes for the people you want to send to, and select OK.

  7. Save your Word file, to save the connections you've made.

Want more?

Discover more courses like this at LinkedIn Learning

Mail merge using an Excel spreadsheet

Prepare your Excel data source for mail merge in Word

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 excel spreadsheet mail merge contact document office 365   Doc ID:79524
Owner:John B.Group:New Mexico State University
Created:2018-01-22 10:18 MDTUpdated:2018-05-23 14:54 MDT
Sites:New Mexico State University
Feedback:  0   0