I have Windows XP, 2002. When I'm trying to do a mail merge and asked to
select a table, it always says data base cannot be opened. Even when I get
an opportunity to select a sheet (which doesn't always happen) and I click on
it, I still get the same message. I have an Excel file I'm trying to use.
I've used the mail merge toolbar and tried mail merge wizard and get the same
results with both. Thanks for any suggestions or help.
From the Tools menu in Word, select Options and then check the box against
the "Confirm conversions and Open" item on the General tab.
Then when you attach the datasource, try the different methods of connection
that are available.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
>I have Windows XP, 2002. When I'm trying to do a mail merge and asked to
> select a table, it always says data base cannot be opened. Even when I
[quoted text clipped - 5 lines]
> same
> results with both. Thanks for any suggestions or help.