Microsoft Office Tutorials and References
In Depth Information
Topic A: Form letters
Do it!
A-3: Specifying a starting document and recipient list
The files for this activity are in Student Data folder Unit 1\Topic A .
Here’s how
Here’s why
1 Click the Mailings tab
2 In the Start Mail Merge group,
click Start Mail Merge and
choose Letters
To specify that the starting document is a form
letter.
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
folder
Student Data folder Unit 1\Topic A.
Select Contacts
You’ll use this Excel file as the data source.
Click Open
The Select Table dialog box opens with the
Employees worksheet selected.
Verify that First row of data
contains column headers
is checked
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.
Click OK
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
Search JabSto ::




Custom Search