Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge returns "0" where I want data instead
I'm trying to create a Word directory from a list of addresses/data I have in
Excel. I follow the usual Mail Merge process through Word, and everything seems to merge properly - except for 4 columns in the middle of my data file. The data all looks fine in the Excel file, and there's nothing unusual about them - in fact, they're identical (in terms of formatting/data type) to the 4 columns prior to them. But when I get to the "choose mail merge recipients" window in Word (where you can select/sort/refresh/validate the recipients), it's like those 4 columns have been overwritten - in place of each cell's original data, there's a "0". And only in those cells where there was data originally; blank cells stay blank. What's happening here, and how do I fix it? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge returns "0" where I want data instead
See the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Liltingbelle wrote: I'm trying to create a Word directory from a list of addresses/data I have in Excel. I follow the usual Mail Merge process through Word, and everything seems to merge properly - except for 4 columns in the middle of my data file. The data all looks fine in the Excel file, and there's nothing unusual about them - in fact, they're identical (in terms of formatting/data type) to the 4 columns prior to them. But when I get to the "choose mail merge recipients" window in Word (where you can select/sort/refresh/validate the recipients), it's like those 4 columns have been overwritten - in place of each cell's original data, there's a "0". And only in those cells where there was data originally; blank cells stay blank. What's happening here, and how do I fix it? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
Mail Merge can't find data source in Office XP...but it could in 2000! | Mailmerge | |||
Mail Merge Data Question | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |