Mail Merge - Excel Data File to Word

Mail Merge - Excel Data File to Word - Zip Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeevan - 30 Jun 2004 22:53 GMT

- While using Word 2002 for a mail merge and using an
Excel 2002 data file with a column for Zip Codes, the
leading zero for the zip code doesn't appear..

- I couldn't find a patch that would fix it.

- What options do I have? I would prefer something easy.

Thanks.

Reply to this Message

Graham Mayor - 01 Jul 2004 05:57 GMT

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

> - While using Word 2002 for a mail merge and using an
> Excel 2002 data file with a column for Zip Codes, the
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Peg Calvarese - 01 Jul 2004 19:24 GMT

Format the column in excel to text and this will keep the
zero in the merge.

>-----Original Message-----
>- While using Word 2002 for a mail merge and using an
[quoted text clipped - 8 lines]
>
>.

Reply to this Message

Rate this thread: