[B.A.D.]

Why does mailmerge remove the first zero from the zipcode area of the address
line? It is definitely not the source formatting, but for some reason it
always takes it out and I do not know how to fix it! I am pulling my
information from an Excel sheet so I do not think it is software
compatability issues. Can anyone help???

[Doug Robbins - Word MVP]

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

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


--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"B.A.D." wrote in message
...
Why does mailmerge remove the first zero from the zipcode area of the
address
line? It is definitely not the source formatting, but for some reason it
always takes it out and I do not know how to fix it! I am pulling my
information from an Excel sheet so I do not think it is software
compatability issues. Can anyone help???

[macropod[_2_]]

Hi B.A.D,

The following field code correctly formats 5-digit and 5+4-digit Zip Code data, even where the source data may have incorrect
formatting such as a hyphen followed by trailing 0s after plain 5-digit Zip Codes (eg because a db only accepts Zip Codes in the
5+4-digit format) or is formatted as a 5-digit or 9-digit string without hyphens. A data field named €˜ZipCode is assumed.
{QUOTE
{SET Zip {MERGEFIELD ZipCode}}
{IF{Zip} 99999 {SET Zip {Zip \# "00000'-'0000"}}}
"{=-{=-{Zip}-Zip}/2 \# 00000;;}{=-({Zip}*(-1)-Zip)/2 \# ;-0000;}"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"B.A.D." wrote in message ...
Why does mailmerge remove the first zero from the zipcode area of the address
line? It is definitely not the source formatting, but for some reason it
always takes it out and I do not know how to fix it! I am pulling my
information from an Excel sheet so I do not think it is software
compatability issues. Can anyone help???