It would seem that you have the zip code colum formatted as a zip code.
This does not alter the original data, so if a zip code has a leading zero
and Excel recognizes it as a numeric value, the leading zero is dropped.
Formatting in Excel will not alter the way the data is brought into the Word
mail merge. What I've done in the past is to modify the merge code. If you
go the zip code merge field in your Word document, right-click and select
Toggle field codes, you will see something like this:
{ MERGEFIELD "ZipCode"}
In order for Word to put the leading zero in the zip, you need to modify the
merge code to look like this:
{ MERGEFIELD "ZipCode" \# "00000"}
This should work. For more info look up numeric switches in Word help.
--
Michael J. Malinsky
Pittsburgh, PA
"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
Annie623 said:
I have a database in Excel. Even though the cell containikng zip codes is
formatted as such, when I do the mail merge with Word, the leading 0 gets
dropped from the zip code. How do I correct this?
