Mail Merge with Long Zip Codes

[buena]

I am trying to do a mail merge in Word 2002 from an Excel spread sheet. There is a Zip Code column in the spreadsheet
that contains both standard and long zip codes.

Ex.
Standard: 63141
Long: 63115-2117

For some reason after doing the merge the long zip codes are displayed as 0. Everything else works as it should.

Has anyone run into this problem?

 

[SkipVought]

buena,

You may have to do your mail merge in 2 batches - filter the zip codes. Unfortunately the MIXED FORMATS are going to be a problem because the SHORT zip codes are interpreted as NUMBERS and the LONG zip codes are interpreted as CHARACTER STRINGS. (for instance the zip code number displayed as 02167 and a CHARACTER STRING 02167 are VASTLY DIFFERENT VALUES)


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884