Outlook security "aprogram is trying to access.."

[Steve Burr]

Hi,

I am using word vba to automate sending an email with a hyperlink in the
body. When I added the coding to include the signature the security setting
is triggered. Code is below. Is there a workaround or solution I am missing?

Kind regard and many thanks

PS. I apologize to anyone who replied to the post in the general section. My
error.

Extract of code
'Create a new mailitem
Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
oItem.To = ""
oItem.Subject = sDsp
oItem.Display
oItem.HTMLBody = "<a href='" & sHpl & "'>" & sDsp & "</a>" &
oItem.HTMLBody & vbCrLf
End With

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.

 

[JP]

You mentioned the code that inserts the signature is triggering the
security prompt, could you post that portion of the code?


Thx,
JP

 

[Ken Slovak - [MVP - Outlook]]

That's the Outlook security that's been around since Outlook 2000 SP2. See
http://www.outlookcode.com/article.aspx?id=52 for your options.

 

[ND Pard]

I had problems with MS Access VB when I tried to send an email through Outlook.

Fortunately, we have a SMTP server and I found a GREAT workaround at:

http://www.access-programmers.co.uk/forums/showthread.php?t=97854

I was able to copy and use (modify) the code posted by BCullenward.

Now I no longer receive Outlook Security Dialogue alerts and it works super
fast too.

Hope that helps a little. Good Luck.