+ Reply to Thread
Results 1 to 5 of 5

VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from Exce

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from Exce

    Hello,

    When I run a macro from Excel to send an e-Mail, it displays a warning that I either must Allow or Deny. I want to Allow, without ever seeing this prompt.

    I have attached an example!

    Thanks for all of your help in advance.
    Attached Images Attached Images

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from

    Hello EnigmaMatter,

    Sorry, you can't do that. It is part of the built-in security for Outlook. It has been that way since Outlook 10.0.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from

    Can't you create an instance of outlook, an object, and send from outlook without the message?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from

    Hello Solus,

    The security check is part of the application program. You won't bypass the message by creating a new instance because the instance class is the same as the application clalss.

  5. #5
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: VBA to Automatically Allow/Ignore Microsoft Outlook Message When Executing Macro from

    Thanks! I'll just have it .Display then.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Microsoft outlook 2003 - Delay the delivery of a single message
    By EmmaGreen in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 11-21-2012, 07:47 AM
  2. Using Excel Macro to Control Microsoft Outlook
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2012, 04:26 PM
  3. [SOLVED] Executing an excel macro and emailing a column in Outlook . .
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2006, 12:35 PM
  4. [SOLVED] A general question regarding Financials Formulas in Microsoft Exce
    By Swhouston055 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-04-2005, 02:05 PM
  5. [SOLVED] Disable Warning Message from Microsoft Outlook in Excel VBA
    By Harvey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2005, 07:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1