View Single Post
 
Old 01-12-2022, 03:57 PM
Souriane Souriane is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Feb 2017
Location: Quebec, Canada
Posts: 82
Souriane is on a distinguished road
Question Open MailMerge Documents and Ignore SQL Security Message

Hi,

I have 500 templates all linked to different databases for Mail merging. Last week, our DNS servers changed name so when we open these templates, it's a mess!

I have a macro that will open each template and reassigned the proper MailMerge DataSource and SQL Statement.

My problem is when the macro opens the documents, there is the SQL Security message that appears and now that I am working in VDI, I am no longer allowed to toggle the Security in the Registry Editor and the administrator won't allow me.

Is there a code to add to the macro to ignore the SQL Security message when it opens each document?

Thank you for your help!

Souriane
Reply With Quote