Zip Codes w/Extentions result in Zero appearing in field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FUMC - 28 Sep 2007 21:00 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 29 Sep 2007 04:48 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

>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
[quoted text clipped - 12 lines]
> 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.

Reply to this Message

FUMC - 01 Oct 2007 14:58 GMT

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?

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 17 lines]
> > 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.

Reply to this Message

FUMC - 01 Oct 2007 15:09 GMT

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.

Reply to this Message