Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data lost in merge from Excel to Word
I'm trying to merge data from Excel to Mail Merge in Word, and some of my
data is getting lost--when I insert it into Word, it just shows up as a zero. I've resaved the data file, refreshed it, closed it, moved the data to a different column--none of this works. Some columns show up fine in the merge; others simply turn to zeros. Any help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data lost in merge from Excel to Word
Post this in a Word newsgroup, it's not really an Excel question.
-- Regards, Peo Sjoblom "Dordty Dave" <Dordty wrote in message ... I'm trying to merge data from Excel to Mail Merge in Word, and some of my data is getting lost--when I insert it into Word, it just shows up as a zero. I've resaved the data file, refreshed it, closed it, moved the data to a different column--none of this works. Some columns show up fine in the merge; others simply turn to zeros. Any help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data lost in merge from Excel to Word
But it FEELS like an Excel issue, doesn't it? I've had problems with the
zeros, too, and found your situation oddly comforting. This morning, I found the answer, and it saved me HOURS! You actually fix the problem in Word. Try this: Open a Word document. Go to Tools. Select Options. Choose the General tab. Select Confirm Conversion at Open. Click ok. Open Mail Merge Wizard. Browse and find your Excel document. Confirm Data Source will come up. Select MS Excel Worksheets via DDE (*.xls). Worked like a charm. "Dordty Dave" wrote: I'm trying to merge data from Excel to Mail Merge in Word, and some of my data is getting lost--when I insert it into Word, it just shows up as a zero. I've resaved the data file, refreshed it, closed it, moved the data to a different column--none of this works. Some columns show up fine in the merge; others simply turn to zeros. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Excel Data into Word Document | Excel Discussion (Misc queries) | |||
How do I merge data from excel into a Word template? | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Word merge with Excel data | Excel Discussion (Misc queries) | |||
Word mail merge with Excel data | Excel Worksheet Functions |