Address Block question

[tjtjjtjt]

Using Word XP, I'm trying to insert a Mail Merge Address block using an Excel XP spreadhseet as the source. We store all of our zip codes in the Zip Format. The address block eliminates opening zeroes. To fix the problem, I have to edit the Addrss Block Code to exclude the POSTAL part, and then insert a MERGEFIELD Zip with a number format attached. This is a bit tedious, and I was hoping there was a better solution. Can it be done with VBA (I have very little experience with VBA)?

tj

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Try converting the column in Excel to Text

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP