+ Reply to Thread
Results 1 to 12 of 12

Outlook Warning when using Excel VBA

  1. #1
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Outlook Warning when using Excel VBA

    Hi,

    I have an Excel file, which has some content and after some criteria is met the VBA code sends the mail using Outlook app to recipient.

    The code works perfectly, but on some computers when the criteria is met and the code is triggered to create a mail and use Outlook, the pop up Window appears, asking to Deny or Allow to another program to use Outlook.

    Because the code is written to make mail sending automatic, I also need to remove this Warning window.

    I know that it can be resolved removing security restriction from Trust Center Settings, by choosing Never Warn me about suspicious activities, in programmatic Access section, but this option is not available, mostly may be that my user does not have administrative rights and it is managed by other administrator.

    How can I resolve this issue?

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Outlook Warning when using Excel VBA

    Hi G

    see this link...

    http://www.rondebruin.nl/win/s1/security.htm
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Outlook Warning when using Excel VBA

    Unfortunately I cant find out there the solution, can you help me there? I am using Outlook 2010

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Outlook Warning when using Excel VBA

    Hi G

    I don't have that issue with Outlook 2007...don't have Outlook 2010.

    You might check this link

    http://office.microsoft.com/en-us/ou...001229943.aspx

  5. #5
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Outlook Warning when using Excel VBA

    I have read this thread, but as it indicates the main issue which causes this Security warning is obsolete database of Antivirus, but I regularly update the antivirus.
    So if you could help me with anything else, I will appreciate it.

    Thank you for your time.

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Outlook Warning when using Excel VBA

    All I can really tell you is that I don't have this issue in Outlook 2007. I DO have it in Outlook 2003 and the Link I sent you deals with the Excel 2003 issue.

    Sorry, don't have any further suggestions.

  7. #7
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Outlook Warning when using Excel VBA

    Thank you again your time and consideration

  8. #8
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Outlook Warning when using Excel VBA

    What is this setting set to in Outlook?

    View security settings in the Trust Center
    The Programmatic Access security settings in the Trust Center provide the following options:

    Warn me about suspicious activity when my antivirus software is inactive or out-of-date (recommended) This is the default setting in Office Outlook 2007. Suspicious activity refers to an untrusted program attempting to access Outlook.

    Always warn me about suspicious activity This is the most secure setting and you will always be prompted to make a trust decision when a program attempts to access Outlook.

    Never warn me about suspicious activity (not recommended) This is the least secure setting.

  9. #9
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Outlook Warning when using Excel VBA

    The setting is set to first one: Warn me about suspicious activity when my antivirus software is inactive or out-of-date (recommended) This is the default setting in Office Outlook 2007. Suspicious activity refers to an untrusted program attempting to access Outlook. but as it is mentioned it is a default option, and it cant be changed as at the bottom it states the Antivirus is VALID. But as I have read if I turn off the antivirus, I can edit this options already, however on my computer I cant do that, as I have no administrative rights and I cant edit any option of my antivirus.

  10. #10
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Outlook Warning when using Excel VBA

    I have the same setting as you described...also the notation...Antivirus is VALID. I don't get any warnings.

    You certainly don't want to turn off the Antivirus Software. Don't know...perhaps the System Admin can help.

  11. #11
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    256

    Re: Outlook Warning when using Excel VBA

    May be there is any other issue, or the antivirus is messing up. I will check with administrator, thank you..

  12. #12
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Outlook Warning when using Excel VBA

    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ 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. email through outlook with out warning box??
    By azureriders in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2011, 08:45 AM
  2. Outlook Email Warning
    By thompsy121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2009, 03:53 PM
  3. [SOLVED] Outlook Warning Messages
    By AD108 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2006, 01:10 PM
  4. [SOLVED] How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2005, 05:06 PM
  5. 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