View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default zip code starting with 0 to show in merged letter

Hi Debbie,

To control the zip-code number formatting for a 5-digit zip-code in Word, add a numeric picture switch to the mergefield. To do
this:
.. select the field;
.. press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD ZipCode};
.. edit the field so that you get {MERGEFIELD ZipCode \# 00000}
.. press F9 to update the field
.. run your mailmerge.

If you're using 5+4-digit Zip Codes, the following field code correctly formats both 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]


"Debbie" wrote in message ...
when I merge zip codes starting with 0 into letters the 0 doesn't show
up...how can I get it to show?