Reply
 
Thread Tools Display Modes
  #1   Report Post  
lbradsha@erols
 
Posts: n/a
Default Mail Merge dropping leading zeroes from the zip code

I'm doing a Mail Merge from an Excel document. Mail Merge is dropping the
leading zeroes from the zip codes plus dropping the hyphen from the nine
digit zip codes.

How do I fix this?

Thanks!
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"lbradsha@erols" wrote in message
...
I'm doing a Mail Merge from an Excel document. Mail Merge is dropping the
leading zeroes from the zip codes plus dropping the hyphen from the nine
digit zip codes.

How do I fix this?

Thanks!



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 drops leading zero from zip code 07001 comes out 7001 Carl Mailmerge 4 August 19th 05 06:20 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM
Leading spaces in Mail Merge field not printing Cindy M -WordMVP- Mailmerge 0 November 30th 04 05:25 PM


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