As always, Microsoft makes things much more complicated than necessary. If a
field is coded as zip, then the number should be stored that way. How stupid
not to carry it also what purports to be an intergrated system.
--
edg
"Doug Robbins - Word MVP" wrote:
The formatting in Excel only governs the way in which Excel displays the
data, not the way in which it is stored and Word just uses the data as it is
stored. To get the desired formatting in Word, it is necessary to add a
formatting switch to the Mergefield.
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at
http://www.gmayor.com/formatting_word_fields.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"MosskinsInNY" wrote in message
...
I have been doing mail merges for nearly 20 years and this has me confused.
I am used to Office 2000 and am now using Office 2003 (whether that
accounts
for this I rather doubt).
I am merging into Word (mailing labels) from an Excel file. Everything
looks fine in Excel, but when I merge, any zip code that begins with a "0"
defaults to a single "0" when printing. The column is formatted for "zip
code +4". I have also tried "zip code", and "test" and inserted all those
pesky apostrophes.
Once I did get the labels to come up on my monitor with the correct zip
codes, but when they printed, the postal codes on the first page were
duplicated on all the following pages (NOT what was on the screen).
Anyone out there know how to help? It would be greatly appreciate as we
are
coming into "bulk mail season".
Thanks!