Outlook security "aprogram is trying to access.."

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Burr - 28 Feb 2008 00:15 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Feb 2008 02:33 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

> Hi,
>
[quoted text clipped - 17 lines]
> oItem.HTMLBody & vbCrLf
> End With

Reply to this Message

JP - 28 Feb 2008 14:34 GMT

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

Thx,
JP

On Feb 27, 7:15 pm, Steve Burr <SteveB...@discussions.microsoft.com>
wrote:

> Hi,
>
[quoted text clipped - 17 lines]
> oItem.HTMLBody & vbCrLf
> End With

Reply to this Message

Ken Slovak - [MVP - Outlook] - 28 Feb 2008 14:58 GMT

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.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

> Hi,
>
[quoted text clipped - 20 lines]
> oItem.HTMLBody & vbCrLf
> End With

Reply to this Message

ND Pard - 05 Mar 2008 21:22 GMT

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.

> Hi,
>
[quoted text clipped - 17 lines]
> oItem.HTMLBody & vbCrLf
> End With

Reply to this Message