Office 2016 at Work For Dummies
Book image
Explore Book Buy On Amazon

After you choose the main document type in Microsoft Office, you next choose the data list. A data list must be in a structured format, such as a Word document containing a table, an Excel workbook, or a database such as the Contacts list in Outlook.

If you plan on using an existing Word or Excel file, it’s important to set it up beforehand. You might need to open that file separately to prepare it.

If it’s a Word table, keep these points in mind:

  • Make sure that there is nothing above the table in the document file.

  • The first row of the table must contain the field names (column labels).

  • All the rest of the rows must contain the data records.

    A Word table suitable for use as a mail merge data list.
    A Word table suitable for use as a mail merge data list.

If it’s an Excel worksheet, keep these points in mind:

  • Row 1 must contain the field names (column labels).

  • All contiguous rows below row 1contain the data records.

    An Excel worksheet suitable for use as a mail merge data list.
    An Excel worksheet suitable for use as a mail merge data list.

When your data source file is ready, follow these steps to connect it to your main document in Word:

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

  2. Click Use an Existing List.

    Choose to use an existing list.
    Choose to use an existing list.
  3. Navigate to the location containing your data file and select it.

  4. Click Open.

    Select the data file and click Open.
    Select the data file and click Open.

Congratulations, your data file is now attached. You won’t notice anything different yet, though, because you must insert merge fields.

About This Article

This article is from the book:

About the book author:

Faithe Wempen, M.A., has written more than 140 books on computer hardware and software, including Microsoft Office 2016 for Seniors for Dummies and The PowerPoint Bible. A Microsoft Office Master Instructor, she has educated more than a quarter of a million corporate students with her online courses, and hundreds more as an adjunct instructor at Purdue University.

This article can be found in the category: