Zip code formating in mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 16 Jun 2005 21:28 GMT

When doing a mail merge from Excel into Word (both 2003) the zip code
suppresses the leading zeros in some zip codes and fould up the zip plus 4
codes as well. When you look at the fields format in Excel, it show to be
correct and everything looks fine until it is pulled into Word. Is this some
sort of bug?
I've tried everything from changing the zip field to text, general, number
it doesn''t seem to make any difference
Thanks for any help you can give.
Randy

Reply to this Message

Doug Robbins - 16 Jun 2005 23:42 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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

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

> When doing a mail merge from Excel into Word (both 2003) the zip code
> suppresses the leading zeros in some zip codes and fould up the zip plus 4
[quoted text clipped - 6 lines]
> Thanks for any help you can give.
> Randy

Reply to this Message

camell - 20 Jul 2005 15:44 GMT

My zipcode is a little bit different then the examples on this web page. The
zipcodes in my Excel document are like this 02345-9899. I either get
00000-0000 or 0 depending on which format I use. Any other suggestions?

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 11 lines]
> > Thanks for any help you can give.
> > Randy

Reply to this Message

Doug Robbins - 20 Jul 2005 18:57 GMT

You will need to create a new column in Excel that by using the Left() and
Right() functions combines the first 5 digits with the final 4, and thus
eliminates the -. Then the method on Graham's website will work. It
doesn't work at the moment because

(a) 02345-9899 is not being considered as a number and/or

(b) it is not > 99999

as it would be if the information stored in Excel was 23459899

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

> My zipcode is a little bit different then the examples on this web page.
> The
[quoted text clipped - 20 lines]
>> > Thanks for any help you can give.
>> > Randy

Reply to this Message

Rate this thread: