Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
My zip code format is lost when merging from Excel to Word...
I just purchased Microsoft Small Business with Outlook 2007 on new Dell and
I'm having the same problem, and I see it is almost 4 years later. Although I clicked on the link that "Suzanne S. Barnhill" posted I don't see that this solved the problem. Were you ever able to fix the problem of dropped zeros on zip codes? "MarianneME" wrote: I am merging addresses from Excel to Work and I lose zip code formatting during the merge so that for all zip codes that begin with a zreo, the zero is dropped. I have never had this problem before, how can I fix this? Thanks! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
My zip code format is lost when merging from Excel to Word...
The issue concerns the way Word mail merge connects to its data source,
which was changed for Word 2002 as the previous method DDE was unreliable. Word now reads the underlying data without any formatting applied by Excel hence leading zeros are stripped. The simplest answer is to use a formatting switch - see the Zip code section of http://www.gmayor.com/formatting_word_fields.htm . Or you can revert to DDE albeit with the inherent risk that DDE is unreliable, the method linked from that page. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MaggieDonuts wrote: I just purchased Microsoft Small Business with Outlook 2007 on new Dell and I'm having the same problem, and I see it is almost 4 years later. Although I clicked on the link that "Suzanne S. Barnhill" posted I don't see that this solved the problem. Were you ever able to fix the problem of dropped zeros on zip codes? "MarianneME" wrote: I am merging addresses from Excel to Work and I lose zip code formatting during the merge so that for all zip codes that begin with a zreo, the zero is dropped. I have never had this problem before, how can I fix this? Thanks! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
My zip code format is lost when merging from Excel to Word...
I simply gave up trying to use Small Business and went back to my old
computer, hoping the mother board doesn't die on me, and continued to print postcards with addresses directly from that computer. However, an associate has figured out how publisher can print each of 1200 addresses on the postcards I send. I also have a business "Market Advantage" program from my company that allows me to maintain business contacts and notes. So I figured Microsoft's Small Business Contact Manager was just not worth my time. If you haven't figured out already, I'm not a computer genius, but I do manage okay. "MaggieDonuts" wrote: I just purchased Microsoft Small Business with Outlook 2007 on new Dell and I'm having the same problem, and I see it is almost 4 years later. Although I clicked on the link that "Suzanne S. Barnhill" posted I don't see that this solved the problem. Were you ever able to fix the problem of dropped zeros on zip codes? "MarianneME" wrote: I am merging addresses from Excel to Work and I lose zip code formatting during the merge so that for all zip codes that begin with a zreo, the zero is dropped. I have never had this problem before, how can I fix this? Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
My zip code format is lost when merging from Excel to Word... | Microsoft Word Help | |||
Merging from excel but the currency format changes on word! | Mailmerge | |||
Why is formating (zip & phone) lost when merging from Excel to Wo. | Mailmerge | |||
zeroes not printing in zip code field when merging from excel to w | Mailmerge |