Home

How to Create a New Data List for Mail Merge in Office 2016

|
Updated:  
2016-03-26 7:15:22
|
Microsoft Power Platform For Dummies
Explore Book
Buy On Amazon

If the data list doesn’t already exist, you can choose to create it in a Word table or in Excel, and then attach it to the main document. However, there’s another way to create a data list that is a little easier (or at least a little more foolproof), especially if the list you are planning to create contains people’s names and addresses:

  1. With the main document open, on the Mailings tab, click Select Recipients.

  2. Click Type a New List.

    Choose to type a new list.
    Choose to type a new list.
  3. Type the name and address, pressing Tab to move to the next fields (column).

    You don’t have to fill in all the fields for every person; just do the ones that pertain to the merge you are going to perform, such as name and mailing address.

  4. Click New Entry and then type another person’s information on the next row.

  5. Repeat step 3 until all the records are entered.

  6. Click OK. The Save Address List dialog box opens.

    Choose to type a new entry.
    Choose to type a new entry.
  7. Type a name for the list in the File name box.

  8. Navigate to a different save location if desired. The default location is My Data Sources in your personal Documents folder.

  9. Click Save.

    Specify a data file name and location.
    Specify a data file name and location.

If you later need to edit that file, choose Mailings→Edit Recipient List. The saved file is in Microsoft Access database format, so you can also open and edit it with Microsoft Access.

About This Article

This article is from the book: 

About the book author:

Faithe Wempen, M.A., is a Microsoft Office Master Instructor and the author of over 150 books on computer technology, including Outlook 2019 for Dummies and PowerPoint Bible. She is also a CompTIA A+ certified PC technician and an adjunct Computer Technology instructor at Purdue University. Her online courses in Office applications and digital literacy have educated over a quarter of a million students for corporate clients.