No the excel workbook is closed. I open word and then ask to open the data
source. that is when it says cannont open data source.
"Peter Jamieson" wrote:
Is the Excel workbork already open (e.g., do you have your old mail merge
main document with the Excel workbook attached open as you work, or are you
starting from a Word template that has the Excel sheet attached as a data
source)?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"stacey" wrote in message
...
I use mail merge all of the time and am baffled by this one. I just did a
mail merge project where I merged data from an excel spreadsheet into a
word
document. I need to create a new mail merge using a new word document and
the same spreadsheet and it comes up as if it is opening excel and than
says
word cannot open document. I have tried everything I can possibly think
of.
Any suggestions?