Zip Codes showing as 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pcakes - 07 Apr 2006 18:30 GMT

I have done a mail merge from an Excell file creating mailing labels, on the
screen I can see the zipcodes, however when I print them several of the
zipcodes show up as 0 (zero). Can you explain why this is, and propose an
answer.

Thanks!

Reply to this Message

Graham Mayor - 08 Apr 2006 06:36 GMT

I assume this is Word 2002/3? From the Tools menu in Word, select Options
and then go to the General tab and check the box against the "Confirm
conversions at open" item. Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.

See also http://www.gmayor.com/formatting_word_fields.htm

Signature

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

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

> I have done a mail merge from an Excell file creating mailing labels,
> on the screen I can see the zipcodes, however when I print them
> several of the zipcodes show up as 0 (zero). Can you explain why
> this is, and propose an answer.
>
> Thanks!

Reply to this Message