Reply
 
Thread Tools Display Modes
  #1   Report Post  
Carl
 
Posts: n/a
Default Mail merge drops leading zero from zip code 07001 comes out 7001


  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



  #3   Report Post  
John
 
Posts: n/a
Default

Thank you for the information. It worked perfectly.

Though I am still confused as to why Word drops the leading zero.
--
John


"Graham Mayor" wrote:

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




  #4   Report Post  
Merging Zip Code Errors
 
Posts: n/a
Default

This is cool, but what about when part of the list is a five digit zip and
part is 5+4? I checked out your website, but I don't want the five digit ones
to format as 12345+0000. I'd rather they just printed 12345. Any suggestions?
I don't want it to have to be an all for nothing deal.

"Graham Mayor" wrote:

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




  #5   Report Post  
Doug Robbins
 
Posts: n/a
Default

Use

{ IF { MERGEFIELD Zip } "99999" "{ MERGEFIELD Zip \# "00000'-'0000" }"
"{ MERGEFIELD Zip \# "00000" } }

--
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
"Merging Zip Code Errors"
wrote in message ...
This is cool, but what about when part of the list is a five digit zip and
part is 5+4? I checked out your website, but I don't want the five digit
ones
to format as 12345+0000. I'd rather they just printed 12345. Any
suggestions?
I don't want it to have to be an all for nothing deal.

"Graham Mayor" wrote:

Use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org






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
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Mail Merge Problem Cindy M -WordMVP- Mailmerge 0 November 30th 04 06:25 PM
Leading spaces in Mail Merge field not printing Cindy M -WordMVP- Mailmerge 0 November 30th 04 06:25 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM


All times are GMT +1. The time now is 06:39 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"