 |
 | 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 / April 2008Zip + 4 showing as 0 on lables
I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4 format (12345-1234) are showing up as zeros. Is there a way to fix this other than doing the switching formulas? I'm not that savvy at Word and am intimidated by the formulas. It used to be so easy!  SignatureGTS Hi GTS, See the topic 'US Zip Codes' on fellow MVP Graham Mayor's website at: http://www.gmayor.com/formatting_word_fields.htm Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4 > format (12345-1234) are showing up as zeros. > > Is there a way to fix this other than doing the switching formulas? I'm not > that savvy at Word and am intimidated by the formulas. It used to be so easy! See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm Alternatively, you will need to format the data in Excel as Text. SignatureHope 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 > I'm doing a mail merge from an Excel sheet and all the zip codes in the > zip+4 [quoted text clipped - 4 lines] > that savvy at Word and am intimidated by the formulas. It used to be so > easy! Thanks to both of you. I have never done "switching"but will try it today. I work in a pool of staff that will also be doing mailings that merge with different Excel spreadsheets, each with similar formats, but not necessarily. I'm the most tech-savvy of all of them (scary, huh?). Is this something I need to do ever time I do a mail merge? Is this something my co-workers will have to do every time, or is it something that changes the customization in Word for that particular user? Does anyone have any ideas about how to manage this for a pool of non-techies? Thanks again for your help! PS. I can't believe I spelled labels wrong in the original post! SignatureGTS > I'm doing a mail merge from an Excel sheet and all the zip codes in the zip+4 > format (12345-1234) are showing up as zeros. > > Is there a way to fix this other than doing the switching formulas? I'm not > that savvy at Word and am intimidated by the formulas. It used to be so easy! Hi GTS, It's a one-off exercise for each mailmerge template (provided you save the template after making the change). Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > Thanks to both of you. > [quoted text clipped - 18 lines] >> Is there a way to fix this other than doing the switching formulas? I'm not >> that savvy at Word and am intimidated by the formulas. It used to be so easy!
|
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.