Home |
Search |
Today's Posts |
#1
|
|||
|
|||
zip codes become 0 after merge excel to word
About half the records show up as a 0 in the zip code field after I merge
into Word to create mailing labels. I have reformatted the column to text, tried formatting as special zip code, but stil about half the records merge as 0 zip even though there is a 5 digit zip in the Excel file...this is driving me crazy! I did sort the workbook by zip code for bulk mail. Does anybody have any suggestions? |
#2
|
|||
|
|||
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. cpoling wrote: About half the records show up as a 0 in the zip code field after I merge into Word to create mailing labels. I have reformatted the column to text, tried formatting as special zip code, but stil about half the records merge as 0 zip even though there is a 5 digit zip in the Excel file...this is driving me crazy! I did sort the workbook by zip code for bulk mail. Does anybody have any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Merging Excel Data into Word | Excel Discussion (Misc queries) | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |