Hi Amalthea,

my MDAC is up to date
and I am still having the same problem. I have gone as far as to
remove Microsoft office and reinstall it as well. And it still does
not work. Any other suggestions?

I'm afraid not. You can try searching microsoft.com for the error
message you're seeing, but as long as the problem is not with Outlook,
there's not much else there.

FWIW, this appears to be a problem with the OLE DB connection over the
JET provider (both Access and Excel use the same one). You can try
activating "Confirm conversions on open" in Tools/Options/General.
That will let you choose how mail merge connects to the data source.
Try connecting to Excel with the other methods listed, after you
choose the *.xls file (my preference would be ODBC, if I have a
choice).

Other than that, you probably need to contact Microsoft Support to
help you track down what's "gone bad" on your installation.

Ah, wait a sec. The newer versions of MDAC don't necessarily supply the
drivers and providers for Jet (Access). I think you may need to look
for and download a separate tool for this. You might look for that and
see if it helps with the default connection method.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)