Looking for example of merge field switch format zipcode in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

-cg - 10 May 2007 16:22 GMT

I m doing a mailmerge that includes addresses.

I've read the Numeric Picture (\#) field switch, and it gave a lot of good
ideas. But when I try, my zipcodes are often converted to dates. I also see
that my leading 0 is dropped, and my 5+4 zips that have a dash are processed
by subtracting.

They are stored in my excel file in cells with Text format.
Thanks,
-cg

Reply to this Message

Doug Robbins - Word MVP - 10 May 2007 19:30 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 m doing a mailmerge that includes addresses.
>
[quoted text clipped - 8 lines]
> Thanks,
> -cg

Reply to this Message

Peter Jamieson - 10 May 2007 19:32 GMT

For further info. on this see http://tips.pjmsn.me.uk/t0003.htm

I think in this case you'll need to use the DDE option.

Peter Jamieson

>I m doing a mailmerge that includes addresses.
>
[quoted text clipped - 8 lines]
> Thanks,
> -cg

Reply to this Message