Mail merge prints zip as 0 instead of correct code
Hi Penelope,
If you find the problem Peter has alluded to, you can overcome the problem by selecting the Zipcode cells in Excel and use
Find/Replace, with a hyphen as the Find character and nothing for the Replace character. This will turn all the Zipcode text strings
into Zipcode numbers.
The only issue you might then have is that your mailmerge will omit the hyphens for the 5+4 Zipcodes! If so, you can deal with this
by adding some logic to the Word document. A suitable field coding for this is:
{SET Zip {MERGEFIELD ZipCode}}{IF{Zip} 99999 {Zip \# "00000'-'0000"} {Zip \# "00000"}}
where 'ZipCode' is the name of your Zip Code mergefield.
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
[MVP - Microsoft Word]
"Penelope" wrote in message ...
When the mail merge is completed for either envelopes, labels or letters some
of the zip codes are converted to a 0 instead of the complete 5 digit code.
The cells have been formated as number - special - zip code.
|