[FUMC]

Doug, please ignore the previous email. I discovered a link on the page you
recommended, "Mail Merge to Labels with Office XP" and found the workaround
suggested there which solved the problem. Thanks for sending this
information.

"Doug Robbins - Word MVP" wrote:

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

"FUMC" wrote in message
...
I only generate labels from Excel about once a year, so I'm a little rusty,
and have run into a problem that I haven't encountered before and don't
understand.

When I use Word to mail merge the Excel list into labels, it doesn't seem
to
recognize any zip code with an extension and puts a zero in that field
when
they come up in the "Mail Merge Recipients" window and when it merges the
data into the labels.

I'm sure if I drop the dash and last four digits of the extended zip code,
it would solve the problem, but since 2/3rds of the 500+ mailing list
uses
the extended zip codes, I would like to use the zip code extensions. I'm
using MS Office 2003 on a PC running Windows XP.