General discussion

  • Creator
    Topic
  • #2297004

    Outlook Prompt caused by Excel Macro

    Locked

    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?

All Comments

  • Author
    Replies
    • #2685023

      Reply To: Outlook Prompt caused by Excel Macro

      by dklippert ·

      In reply to Outlook Prompt caused by Excel Macro

      It’s the result of a security update:
      Information About the Outlook E-mail Security Update
      http://tinyurl.com/xysr
      Also see:
      Automation Security
      http://tinyurl.com/atlz
      http://tinyurl.com/atlt

      Here’s a progam way out of the problem:
      http://tinyurl.com/1dju

      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.

      • #2686437

        Reply To: Outlook Prompt caused by Excel Macro

        by audit ·

        In reply to Reply To: Outlook Prompt caused by Excel Macro

        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.

    • #2686436

      Reply To: Outlook Prompt caused by Excel Macro

      by audit ·

      In reply to Outlook Prompt caused by Excel Macro

      This question was closed by the author

Viewing 1 reply thread