General discussion


Outlook Prompt caused by Excel Macro

By audit ·
In Office 2000 an associate and I recorded VBA code in an Auto_Open macro in the Excel application that forwards a workbook (which is created daily) to two co-workers using Outlook email. The macro works on her PC but it causes a prompt to come up when it is executed that asks "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?"

This prompt DOES NOT appear when the macro is run from any other users' PCs. What (and where) is the Outlook or Excel setting that needs to be changed to allow the macro to run without bringing up this prompt?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Outlook Prompt caused by ...

It's the result of a security update:
Information About the Outlook E-mail Security Update
Also see:
Automation Security

Here's a progam way out of the problem:

Express ClickYes is a tiny program that sits in the taskbar and clicks the Yes button on behalf of you, when Outlook's Security Guard opens prompt dialog saying that a program is trying to send an email with Outlook or access its address book. You can suspend/resume it by double-clicking its taskbar icon. Developers can automate its behavior by sending special messages.

Collapse -

by audit In reply to

Thanks - Just the information I needed.

It's a shame that Microsoft didn't include a setting within Outlook like they did for Outlook Express.

Collapse -

by audit In reply to Outlook Prompt caused by ...

This question was closed by the author

Related Discussions

Related Forums