How to turn off postal code numeric conversion?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MN Jim - 26 Oct 2006 16:14 GMT

Trying to create address labels from an excel worksheet but word converts the
postal code to number format so I lose all zip + 4 and foreign postal codes.
How do I keep the text formating?

Reply to this Message

Doug Robbins - Word MVP - 26 Oct 2006 19:07 GMT

You may be able to do it by selecting Options from the Tools menu and then
going to the General tab and checking the box against the "Confirm
conversions at open" item. After doing that, when you attach the data
source to the mail merge main document, you will be asked for the method by
which the connection should be made. Try the DDE option.

Also 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

> Trying to create address labels from an excel worksheet but word converts
> the
> postal code to number format so I lose all zip + 4 and foreign postal
> codes.
> How do I keep the text formating?

Reply to this Message

MN Jim - 26 Oct 2006 20:35 GMT

Doug,
I tried the options change and the DDE load option and it worked great!
Thank you.

Jim

> You may be able to do it by selecting Options from the Tools menu and then
> going to the General tab and checking the box against the "Confirm
[quoted text clipped - 12 lines]
> > codes.
> > How do I keep the text formating?

Reply to this Message