Quote:
Originally Posted by Souriane
I have a macro that will open each template and reassigned the proper MailMerge DataSource and SQL Statement.
...
Is there a code to add to the macro to ignore the SQL Security message when it opens each document?
|
See
Run a Mailmerge from Excel, Sending the Output to Individual Files in the
Mailmerge Tips & Tricks 'Sticky' thread at the top of the Mailmerge forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
As demonstrated there, you will need to include the SQL statement in the VBA code. This applies to any code that disables the SQL message, not just to the code in the article.