Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
-cg -cg is offline
external usenet poster
 
Posts: 1
Default Looking for example of merge field switch format zipcode in Word

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Looking for example of merge field switch format zipcode in Word

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

"-cg" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Looking for example of merge field switch format zipcode in Word

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
"-cg" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Field Currency Switch Rounding workliveplay Mailmerge 14 May 5th 07 12:46 AM
Losing zipcode when I merge! Anne Mailmerge 1 April 6th 07 06:38 PM
More than one formatting switch for a merge field sch06 Mailmerge 6 November 2nd 06 11:18 AM
Word Merge - Format Output with Double Spacing - Switch?? ocbarney Mailmerge 2 August 14th 06 07:17 PM
Switch an image dynamically based on mail merge field - possible? Chris Hlusak Mailmerge 1 January 25th 05 12:11 AM


All times are GMT +1. The time now is 12:15 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"