Remove Outlook Security Warning from within Access
Posted on 2007-03-22
Hi all, trust you are well.
Using code such as below to send a email msg from with Access. When i do this a box pops up in Outlook saying "a program is trying to send mail blah blah" Do you want to allow this? Does anyone know of a way to turn that off as the users are hitting cancel and defeating the purpose behind the email.
On Error GoTo UndoChange
Set olApp = Outlook.Application
'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)
If Not IsNull(Me.Combo16.Column(3)) Then
.To = Me.Combo16.Column(3)
.Subject = "Status Change: " & Forms!usrJobs!JobDescription & "-" & Me.SeqNo & " changed from being '" & Me.befStatusID & "' to '" & Me.Combo16.Column(1) & "'"