I don't know much about Vista 64 Enterprise, but I understand that it is
"optimised for security" in various ways. I wonder whether on that system,
the ACE (Access) OLE DB provider that Word would normally use to open an
Excel workbook is actually installed, or disabled in some way. (I find that
slightly difficult to believe if Access is installed, but I suppose it is
possible). That said, Word should then "fall back" to using ODBC (even less
likely to be installed) and then DDE (which might also be disabled, or even
absent, in that configuration). You could see if the ACE provider is there
by going to Word Select Recipients-Use existing list-New Source, select
other/Advanced, click Next, and see if the ACE provider is listed.
A simple test to ensure that it isn't simply /all/ Mail merge data sources
that fail would be to copy/paste your Excel table into a Word document, save
and close, then try to use that as the data source. Or just create a small
table in an empty Word document with a row contaiining column headers and a
few rows of data, and try to use that.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Tom Koski" wrote in message
...
This is the only error I get when trying to open an excel data source in
Word
2007 mailmerge document. This is a Vista Enterprise 64 system - the same
document and spreadsheet works fine on my Win XP Pro 64 system...
The spreadsheet is a simple single sheet workbook with 10 columns and 9
rows, although I have tried it with more complex multi-sheet workbooks,
with
the same results. In fact, I can't get it to open ANY kind of data
source.
Any ideas?
Hopefully,
Tom
--
Thomas Koski
Coastline Exploration, Inc.