[GTS]

I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm not
that savvy at Word and am intimidated by the formulas. It used to be so easy!
--
GTS

[macropod]

Hi GTS,

See the topic 'US Zip Codes' on fellow MVP Graham Mayor's website at:
http://www.gmayor.com/formatting_word_fields.htm

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"GTS" wrote in message ...
I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm not
that savvy at Word and am intimidated by the formulas. It used to be so easy!
--
GTS

[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

Alternatively, you will need to format the data in Excel as Text.


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

"GTS" wrote in message
...
I'm doing a mail merge from an Excel sheet and all the zip codes in the
zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm
not
that savvy at Word and am intimidated by the formulas. It used to be so
easy!
--
GTS

[GTS]

Thanks to both of you.

I have never done "switching"but will try it today. I work in a pool of
staff that will also be doing mailings that merge with different Excel
spreadsheets, each with similar formats, but not necessarily. I'm the most
tech-savvy of all of them (scary, huh?).

Is this something I need to do ever time I do a mail merge? Is this
something my co-workers will have to do every time, or is it something that
changes the customization in Word for that particular user?

Does anyone have any ideas about how to manage this for a pool of non-techies?

Thanks again for your help!

PS. I can't believe I spelled labels wrong in the original post!
--
GTS


"GTS" wrote:

I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm not
that savvy at Word and am intimidated by the formulas. It used to be so easy!
--
GTS

[macropod]

Hi GTS,

It's a one-off exercise for each mailmerge template (provided you save the template after making the change).

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"GTS" wrote in message ...
Thanks to both of you.

I have never done "switching"but will try it today. I work in a pool of
staff that will also be doing mailings that merge with different Excel
spreadsheets, each with similar formats, but not necessarily. I'm the most
tech-savvy of all of them (scary, huh?).

Is this something I need to do ever time I do a mail merge? Is this
something my co-workers will have to do every time, or is it something that
changes the customization in Word for that particular user?

Does anyone have any ideas about how to manage this for a pool of non-techies?

Thanks again for your help!

PS. I can't believe I spelled labels wrong in the original post!
--
GTS


"GTS" wrote:

I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4
format (12345-1234) are showing up as zeros.

Is there a way to fix this other than doing the switching formulas? I'm not
that savvy at Word and am intimidated by the formulas. It used to be so easy!
--
GTS