If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Source Evaporates
In Microsoft Office 2007 Word Mailmerge, When I "Select recipients" and
browse to my data source (a file on Excel) the "Select Table"dialog box pops up with"Sheet 1$" highlighted. Everything is fine up to this point. But then I click OK...AND THAT'S THE END OF IT. I don't get to see my data to confirm and "select all." I can't go any further. Nothing got read. Zip. I've been working on this for two days. If ANYONE can give me some help with this I'd sure appreciate it. Thanks Olaf |
#2
|
|||
|
|||
Data Source Evaporates
1. As an experiment, can you create a completely new workbook with some
test data and try to connect to that? 2. If that works OK, it's almost certainly a problem with the Workbook - either it has been corrupted in some way (in which case, if it's a simple data-only workbook, you could consider exporting to .csv and creating a new workbook from that .csv. Or... - it has other stuff in it that the OLE DB provider does not like. For example, using Excel outlining sometimes seems to cause problems. But if that's the case, I'm not sure I can help. 3. If you are completely stuck, ou should at least be able to export using .csv and use that as the data source for your merge. Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 20:16, Olaf Egeberg wrote: In Microsoft Office 2007 Word Mailmerge, When I "Select recipients" and browse to my data source (a file on Excel) the "Select Table"dialog box pops up with"Sheet 1$" highlighted. Everything is fine up to this point. But then I click OK...AND THAT'S THE END OF IT. I don't get to see my data to confirm and "select all." I can't go any further. Nothing got read. Zip. I've been working on this for two days. If ANYONE can give me some help with this I'd sure appreciate it. Thanks Olaf |
Thread Tools | |
Display Modes | |
|
|