Word Mail Merge automation.
Outlook E-mail Security Update issues. Security Guard

Security Manager
for Microsoft® Outlook®

What Outlook versions trigger security alerts on Mail Merge?

Starting from the Outlook 2000 E-mail Security Update the developers who use the Office Mail Merge functionality run into security prompts that the Outlook Security Guard triggers on Mail Merge automation. If you automate Mail Merge from inside of your applications, you get the security alert on Outlook 2000 with service pack 2 and higher, Outlook 2002, Outlook 2003, Outlook 2007 or Outlook 2010. The Outlook Email Security Guard triggers the following security prompts:

A program is trying to access e-mail addresses you have stored in Outlook

A program is trying to access e-mail addresses you have stored in Outlook

A program is trying to automatically send e-mail on your behalf

program is trying to automatically send e-mail on your behalf

What Outlook Security Manager provides to avoid Outlook security prompts on Mail Merge

Below you can see a stand-alone example that runs Outlook and Word, opens a prepared Mail Merge document and executes Mail Merge. This example uses Outlook Security Manager ActiveX that allows you to avoid Outlook security prompts.

Visual Basic 6.0 (VBA)

Private Sub Command1_Click()
Dim OutlookApp As New Outlook.Application
Dim SecurityManager As New OutlookSecurityManager
Dim WordApp As New Word.Application
Dim WordDoc As Word.Document
Dim MailMerge As Word.MailMerge
WordApp.Visible = True
' Connects to an Outlook instance
SecurityManager.ConnectTo OutlookApp.Application
' Disables security warnings on accessing Outlook objects
SecurityManager.DisableOOMWarnings = True
On Error GoTo Finally
Set WordDoc = WordApp.Documents.Open(CurDir() & "\Test.doc", True)
Set MailMerge = WordDoc.MailMerge
MailMerge.OpenDataSource Name:=CurDir() & "\Test.mdb", _
SQLStatement:="SELECT * FROM [Office_Address_List]"
MailMerge.MailAddressFieldName = "Email_Address"
MailMerge.DataSource.FirstRecord = wdDefaultFirstRecord
MailMerge.DataSource.LastRecord = wdDefaultLastRecord
MailMerge.MainDocumentType = wdEMail
MailMerge.Destination = wdSendToEmail
MailMerge.Execute False
Finally:
' In any case, please remember to turn on Outlook security warnings
' after your code, since now it is very easy to switch it off!
SecurityManager.DisableOOMWarnings = False
End Sub

The code example above is in Visual Basic 6.0, but Outlook Security Manager supports all .NET programming language including Visual Basic .NET, C#, C++, J#, Delphi for .NET, RemObjects Chrome as well as Delphi for Win32, Visual C++ 6, Visual Basic for Applications including Access VBA, Excel VBA, VBScript, JScript, etc.

Find more about how to avoid Outlook security messages like: A program is trying to...

See Also