Mail merge dilemma!!

[kimcox_74]

I am doing a mail merge in word 2003 but taking addresses from an excel
worksheet. When I get to choosing recepients the columns are all messed up.
Basically instead of customer, address, zip it just recognizes address & zip.
Whay is it not recognizing what I have in excel?

 

[Doug Robbins - Word MVP]

What are the field names of your Excel data? Exact spelling including
spaces required.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[kimcox_74]

There are 5 columns.

Customer, Street address, City, State, Zip

Also when I do preview the labels it only does one page of labels.

Thanks!

 

[Graham Mayor]

The preview issue is normal. You have not completed the merge. You must
merge to the printer or to a new document. See
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm#only_one_page
As for the Excel data see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and avoid using
the addressblock field.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[kimcox_74]

Thank you all! i think I got it figured out now!~