Microsoft Office Tutorials and References
In Depth Information
Topic A: Form letters
A-3: Specifying a starting document and recipient list
The files for this activity are in Student Data folder Unit 1\Topic A .
1 Click the Mailings tab
2 In the Start Mail Merge group,
click Start Mail Merge and
To specify that the starting document is a form
3 In the Start Mail Merge group,
click Select Recipients and
choose Use Existing List…
To open the Select Data Source dialog box.
4 Navigate to the current topic
Student Data folder Unit 1\Topic A.
You’ll use this Excel file as the data source.
The Select Table dialog box opens with the
Employees worksheet selected.
Verify that First row of data
contains column headers
To indicate that the first row of data contains the
headings for each column of data.
5 Click OK
You could click Edit Recipient List to open a
dialog box displaying the recipient list data.
6 In the Start Mail Merge group,
click Edit Recipient List
To open the Mail Merge Recipients dialog box.
The list has seven recipients.
To close the Mail Merge Recipients dialog box.
You can now add merge fields, representing the
recipient list data, to the letter.
7 Update the document