[Peter Jamieson]

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