 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / September 2004Merge drops lead 0 in zip Codes
Running into a problem I never experienced previously. When I perform a mail merge using an Excel address database as a source, Zip Codes that begin with "0" come through without the lead "0". Example: Excel cell formatted as a zip code "01234" is merged and displayed on mailing labels in Word as "1234". See section on US zip codes at: http://www.gmayor.com/formatting_word_fields.htm  SignatureGreg Maxey A peer in "peer to peer" support Rockledge, FL To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org > Running into a problem I never experienced previously. When I > perform a mail merge using an Excel address database as a source, Zip > Codes that begin with "0" come through without the lead "0". > Example: Excel cell formatted as a zip code "01234" is merged and > displayed on mailing labels in Word as "1234". |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.