I bet that those offending zipcodes aren't really text--they don't have the
leading apostrophe.
I bet that they've got a custom format:
format|Cells|Number tab
either Special category (zip code)
or
Custom and something like:
00000
(Saved from a previous post.)
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he
http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm
about half way down the page.
==========
I often cheat instead of racking my brain.
I'll insert another column (probably hidden!) and use:
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.
vera wrote:
I have a column of zip codes, some of which begin with '0'. We're using a
mail merge to create letters; we have the apostrophe before the numeric text
so that the '0's will print, but something is happening and halfway through
the merge results the zip codes start losing digits! What can this be?
--
Dave Peterson