F7 in zip field when doing mail merge from excell file
I work with a warehouse set up in access. I do my query to get my info. Then
I copy the data to an excell file. I usually do name & address info. The zip
field looks fine in excell, but when I use the excell file in word to do a
mail merge when I match the fields an F7 appears in the zip field & all my
leading zeros are dropped. The only way to keep my leading zeros is to change
the zip field to "text" and key all the zips with leading zeros and then
bring the file into word for the mail merge. Any help would be appreciated.
|