Mail merge data source problem

[Raj]

Hi,

I have a word document mailmerged with an excel table as a data
source. In the Document.open event of the word document is a macro
that opens the document and sends the merged letters to a new document
(for later printing). Everything works fine, except that when the
workbook with the document.open macro is opened, it warns the user
about running the sql command. I want to say "Yes" to this in the code
so that the mail merge is seamless. How do I say "Yes" to the command
in VBA code?

Thanks in advance for the help

Regards,
Raj

 

[Graham Mayor]

You receive the "Opening this will run the following SQL command" message
when you open a Word mail merge main document that is linked to a data
source - http://support.microsoft.com/?kbid=825765. See also the Word macro
to toggle the registry setting referred to in that link at
http://www.gmayor.com/word_vba_examples.htm#SQL.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>