 |
 | 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 / November 2004mail merge / zip code problem
I did a mail merge to make address labels with addresses from an Excel spreadsheet. When I completed the merge, any zip codes that start with a zero were missing the zero (ie if it was supposed to be 06647, instead it was 6647) How do I correct this? Thank you Use a formatting switch on the field - http://www.gmayor.com/formatting_word_fields.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I did a mail merge to make address labels with addresses from an Excel > spreadsheet. When I completed the merge, any zip codes that start > with a zero were missing the zero (ie if it was supposed to be 06647, > instead it was 6647) How do I correct this? > > Thank you When numbers in Excel are formatted in the General or a Number format, Excel drops leading zero's because they are not significant in doing calculations. Highlight the cells containing the zip codes in Excel, then select Cells from the Format menu. On the Number tab, select Special, ZipCodes. The leading zeros will stick and you will not need to struggle with switches. > Use a formatting switch on the field - > http://www.gmayor.com/formatting_word_fields.htm [quoted text clipped - 5 lines] > > > > Thank you \# "00000" is a struggle? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > When numbers in Excel are formatted in the General or a Number > format, Excel drops leading zero's because they are not significant [quoted text clipped - 22 lines] >>> >>> Thank you I had actually done what PA suggested in order to add the zeroes to my zipcodes. when I do the merge, the zeroes are removed. Graham, I looked at the link you referred me to and I don't understand at all what it is they are telling me to do. Would you be able to explain? Thank you for your help. > \# "00000" is a struggle? > [quoted text clipped - 24 lines] > >>> > >>> Thank you You need to use DDE as the data transfer protocol. If you are not given the choice, in Word choose Options from the Tools menu. On the General tab check Confirm Conersion on Open. You will be good to go. There is nothing wrong with switches, except you have ot deal with them everytime you generate a new merge document. This is a one time thing. Unfortunately, in my opinion, Microsoft made an error when they changed the default from DDE to the current OLEDB. Especially for those of us who merge data from Excel or Access. > I had actually done what PA suggested in order to add the zeroes to my > zipcodes. when I do the merge, the zeroes are removed. [quoted text clipped - 32 lines] > > >>> > > >>> Thank you Eureka! That worked. Thank you. > You need to use DDE as the data transfer protocol. If you are not given the > choice, in Word choose Options from the Tools menu. On the General tab check [quoted text clipped - 42 lines] > > > >>> > > > >>> Thank you Right click the Zip field and toggle the display You will see {Mergefield ZIP} (or something similar) add the switch between the brackets {Mergefield ZIP \# "00000"} Right click and toggle back then F9 to update. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I had actually done what PA suggested in order to add the zeroes to my > zipcodes. when I do the merge, the zeroes are removed. [quoted text clipped - 41 lines] >>>>> >>>>> Thank you |
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.