[FUMC]

I only generate labels from Excel about once a year, so Im a little rusty,
and have run into a problem that I havent encountered before and dont
understand.

When I use Word to mail merge the Excel list into labels, it doesnt 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.

Im 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. Im
using MS Office 2003 on a PC running Windows XP.

[Doug Robbins - Word MVP]

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.

[FUMC]

Doug, I can follow this to a certain point: I see the section on Zip Codes
and the problem I described, I go to Tools/Customize/View Field Codes, but I
don't understand where I go from there to input the "switch" info. Also,
isn't there an easier way for those of us who aren't quite so
technically-minded?

"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.

[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.