Mail Merge/Zip code Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Baffled - 30 Jan 2004 16:31 GMT

Hi.

We just upgraded to Office 2003 and I am having trouble
with the zip field when mail merging from Excel to Word.

For zips starting with zero it's not showing. With every
other versions of Office, I just click on format in Excel
and set the field to zip and that solved it. With this
version, it's not working. Help.

Thanks!

Reply to this Message

- 30 Jan 2004 18:01 GMT

I don't know what to tell you.

>-----Original Message-----
>Hi.
[quoted text clipped - 9 lines]
>Thanks!
>.

Reply to this Message

Greg Maxey - 30 Jan 2004 23:25 GMT

Baffled,

Have your tried a numeric picture switch in your mergefield e.g., {
Mergerfiled Blah Blah \# 00000 }

Signature

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

> Hi.
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Peter Jamieson - 30 Jan 2004 23:30 GMT

The following page from MVP Graham Mayor's website may help:

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

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi.
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

tjtjjtjt - 31 Jan 2004 00:31 GMT

Directly before the Zip Field, Insert a Word Field--the Field you want is If...Then...Else
Set it so that if the Zip Field is less than or equal to 9999, it will insert a 0. Leave the Otherwise part blank.

Reply to this Message

Graham Mayor - 31 Jan 2004 06:34 GMT

Peter's suggestion should work, but look also at the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi.
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Rate this thread: