Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip + 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! -- GTS |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip + 4 showing as 0 on lables
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 -- macropod [MVP - Microsoft Word] ------------------------- "GTS" wrote in message ... 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! -- GTS |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip + 4 showing as 0 on lables
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. -- 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 "GTS" wrote in message ... 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! -- GTS |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip + 4 showing as 0 on labels
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! -- GTS "GTS" wrote: 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! -- GTS |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Zip + 4 showing as 0 on labels
Hi GTS,
It's a one-off exercise for each mailmerge template (provided you save the template after making the change). Cheers -- macropod [MVP - Microsoft Word] ------------------------- "GTS" wrote in message ... 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! -- GTS "GTS" wrote: 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! -- GTS |