I created a mail merge word document and a mail merge Excel data file on my Vista32 bit system using Excel 2003. When I open the Word document manually, I get the 'SQL' message.
I ran an Excel macro to run the 'Mail Merge' and it was successful in that it DID NOT get the 'SQL' message. I am not confident that my solution will work on your computer. Color me skeptical. If this doesn't work for you, I still may have one or two more tricks up my sleeve, but it may take a few days.
My files are attached (which include extras) that do the following (all independent of each other):
a. Run the mail merge from Excel.
b. Open a new instance of Word from Excel.
c. Open a Word file (that has an AutoRun macro) from Excel with AutoRun enabled.
d. Open a Word file (that has an AutoRun macro) from Excel with AutoRun disabled.
Lewis
Code for the mail merge follows:
To open a new instance of Word from Excel:
To open a Word document (with AutoRun enabled):
To disable AutoRun place the following line before the line that opens the Word document where 'WordApp' is the Word application object as defined in the previous example:
Bookmarks