Mail-Merge Zip Codes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

W J Carey - 21 Mar 2004 01:39 GMT

I have not been able to merge an excel file that used
formated zip codes into a lable Doc.. It will drop all
zero's proceding the fist number, 08049 turns into 8048
BIG Problem

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 21 Mar 2004 01:55 GMT

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

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

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I have not been able to merge an excel file that used
> formated zip codes into a lable Doc.. It will drop all
> zero's proceding the fist number, 08049 turns into 8048
> BIG Problem

Reply to this Message

Greg Maxey - 21 Mar 2004 01:58 GMT

See the section US Zip codes at:
http://www.gmayor.com/formatting_word_fields.htm

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> I have not been able to merge an excel file that used
> formated zip codes into a lable Doc.. It will drop all
> zero's proceding the fist number, 08049 turns into 8048
> BIG Problem

Reply to this Message

Clint - 22 Mar 2004 07:31 GMT

Try changing the zip code field to a label (non-numeric) in Excel before merging.

Reply to this Message

Suzan - 29 Mar 2004 16:36 GMT

In Excel, try Format, Cells, Special, and change the entries to Zip Code.

Reply to this Message