Open MailMerge Documents and Ignore SQL Security Message

macropod · #9 01-14-2022, 02:21 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide Security Message and Print	rosscortb	Word VBA	1	05-11-2017 03:39 AM
When loading existing documents (*.docx) they load with Security Warning - Macros have been disabled	Franci	Word	3	05-20-2016 04:33 AM
Mailmerge Individual Documents	DaddyMac	Mail Merge	4	06-06-2013 09:22 PM
Excel 2007 security alert - data connection message every time?	michael.monaco	Excel	0	12-20-2012 07:47 AM
Open Word = security warning, changes hard drive	sleepymia	Word	1	05-28-2012 05:49 PM