Mail Merge/Zip code Problem

[Baffled]

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!

 

[Guest]

I don't know what to tell you.

 

[Greg Maxey]

Baffled,

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

 

[Peter Jamieson]

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

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

 

[tjtjjtjt]

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.

 

[Graham Mayor]

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.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>