Merging Data From Excel Into Word Labels

[Jennifer]

Hello,

I would like to merge data from an Excel spreadsheet into
MS Word labels. I have taken the following steps in Word:

1) Tools, MailMerge
2) Create, Mailing Labels
3) Select "Active Window"
4) Select "Get Data"
5) Select "Open Data Source" and open my file in Excel
6) Click on "Entire Spreadsheet", OK
7) Click on "Set up Main Document"
8) Select the "Shipping 2 x 4" Labels, OK
9) This is where I get stsuck ... I have the Create
Labels dialgoe box open, with the option to Insert Merge
Fields or Insert Postal Bar Code. If I select "Insert
Merge Fields" my only options
are "AutoMergeField", "AutoMergeField1", "AutoMergeField2",
and "AutoMergeField3". Shouldn't I have the option to
insert "FirstName", "LastName", "Address1", "City", etc.
These are the headings that are in my Excel spreadsheet.

Please help!!

Thank you,
Jennifer

 

[Graham Mayor]

The following article on the subject should help
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Guest]

Thank you, Graham. I don't have the options that are
described in the document ... maybe because I have Office
2000 Professional Version installed on my computer. Do
you have a document that would pertain to 2000
Professional?

 

[Graham Mayor]

I regret I have not prepared a similar document for earlier Word versions.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>