Microsoft Office Tutorials and References
In Depth Information
The Select Data Source
dialog box appears.
8
Click here and select
the folder in which you
saved your Excel file.
8
9
9
Click your file.
0
Click Open.
0
The Select Table dialog box appears.
l
$
!
Click to select the worksheet that contains
your list.
@
Click if your list does not have column
headings (
!
changes to
).
#
Click OK.
Excel imports your Excel list.
$
Click Edit Recipient List.
The Mail Merge Recipients dialog box
appears.
Your list is ready to use in a mail merge.
l
#
@
Did You Know?
When creating an Excel list for mail-merge
purposes, begin by identifying your data needs.
For name badges, for example, you might not
need address information, but you might need a
new column called Affiliation. For shipping labels,
you might need a customer ID number in
addition to address information. For multiple
tasks, you can use existing lists as templates to
create new ones.
Did You Know?
The Mail Merge Recipients dialog box displays
all the data in your list. You can use it to select,
sort, and filter your list before you perform your
mail merge. You can also use it to find duplicates
in your list or to find a particular recipient.
Chapter 9: Extend Excel
219
 
Search JabSto ::




Custom Search