Mail merge dilemma!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimcox_74 - 15 Nov 2007 17:16 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 15 Nov 2007 19:33 GMT

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

Signature

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

>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?

Reply to this Message

kimcox_74 - 15 Nov 2007 20:42 GMT

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!

> What are the field names of your Excel data? Exact spelling including
> spaces required.
[quoted text clipped - 5 lines]
> > zip.
> > Whay is it not recognizing what I have in excel?

Reply to this Message

Graham Mayor - 16 Nov 2007 06:42 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> There are 5 columns.
>
[quoted text clipped - 21 lines]
>>> address & zip.
>>> Whay is it not recognizing what I have in excel?

Reply to this Message

kimcox_74 - 16 Nov 2007 16:54 GMT

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

> The preview issue is normal. You have not completed the merge. You must
> merge to the printer or to a new document. See
[quoted text clipped - 28 lines]
> >>> address & zip.
> >>> Whay is it not recognizing what I have in excel?

Reply to this Message