Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Field Currency Switch Rounding | Mailmerge | |||
Losing zipcode when I merge! | Mailmerge | |||
More than one formatting switch for a merge field | Mailmerge | |||
Word Merge - Format Output with Double Spacing - Switch?? | Mailmerge | |||
Switch an image dynamically based on mail merge field - possible? | Mailmerge |