Try It: Find the File

Go to the Documents Folder.

Go to All Data Files.

Select Excel for the File Type.

Double click the Friends and Family spreadsheet to select it.

 

Open the Recipients Table

After you find and select the Excel file, the Mail Merge Wizard will ask you to Select a Table. By default, the first spreadsheet in any Excel workbook is named “Sheet1$.” The dollar sign means get all the data, everything.

What Do You See? There is a check mark where it says First row contains column headers. Column headers are the labels-first name, last name that are typed in the top row of the our Friends and Family list.

 

Click OK. Keep going...

 

Exam 77-881: Microsoft Word 2010 Core

7. Performing Mail Merge Operations

7-1. Setup mail merge: Use Existing List



Mailings -> Start Mail Merge ->Select Recipients