Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 10: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 24th 05 11:11 PM


All times are GMT +1. The time now is 11:16 PM.

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"