Which version of Word/Excel?
Is your worksheet the first in the workbook?
Are there any blank rows at the top of the sheet?
Is the sheet open in Excel when you try to connect, or not?
Peter Jamieson
http://tips.pjmsn.me.uk
Alliemd wrote:
For mail merge, after I select my "existing list", which is an Excel
document, the Select Table options are blank. My contact, address, city etc
does not appear in this box. It is blank and it says "Word was unable to open
the data source."
I am able to use other excel documents for my recipient list, but why does
this specific excel document not work with my mail merge? HELP!