The issue concerns the way Word mail merge connects to its data source,
which was changed for Word 2002 as the previous method DDE was unreliable.
Word now reads the underlying data without any formatting applied by Excel
hence leading zeros are stripped. The simplest answer is to use a formatting
switch - see the Zip code section of
http://www.gmayor.com/formatting_word_fields.htm .
Or you can revert to DDE albeit with the inherent risk that DDE is
unreliable, the method linked from that page.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
MaggieDonuts wrote:
I just purchased Microsoft Small Business with Outlook 2007 on new
Dell and I'm having the same problem, and I see it is almost 4 years
later. Although I clicked on the link that "Suzanne S. Barnhill"
posted I don't see that this solved the problem. Were you ever able
to fix the problem of dropped zeros on zip codes?
"MarianneME" wrote:
I am merging addresses from Excel to Work and I lose zip code
formatting during the merge so that for all zip codes that begin
with a zreo, the zero is dropped. I have never had this problem
before, how can I fix this? Thanks!