Zip Codes w/Extentions result in Zero appearing in field

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.

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" <FUMC.TakeThisOut@discussions.microsoft.com> wrote in message
news:6BCA4AB6-1747-4AF0-9CF3-AF891203AD9E@microsoft.com...
>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.
>
>