Some zip codes with 9 digits show up as a 0.

C

Cindy

When doing a mail merge for a directory, the physical address zip code with 9
digits show up as a 0. The 5 digit ones are ok.

-- Cndsue
 
M

macropod

Hi Cindy,

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;}"}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Labels (Word 2007) w/ Excel (2007) 2
Format Zip Codes Correctly for a Mailmerge 3
Leading zero from Zip Code not print on Label Merge 6
Zip Code Last 4 Digit as Zero 1
only 5 digit zip codes 1
Leading 0 in Mail Merge document 4
Changing ZIP code formats in Excel 2003 6
Query with Zip Code Mis-match (5 digit vs 9 digit) 2

Top