How to Avoid Outlook Security Warning Popup Message?
Posted by
Do you still wondering is there a way to avoid "Security warning popup message"?
The answer is "Yes" if you are sending emails without using ".send" method in you code.Assume that you going to create a new email in outlook through excel macro and you are using ".Send" method in your VBA code as a final command to send mail automatically without even displaying the mail item to the user.
But the outlook has inbuilt function to alert the user and get their concurrence to send the email. For that it will show you the popup message as a warning that a "A program is trying to send e-mail message on your behalf, if this is unexpected, click Deny and verify your antivirus software is up-to-date. Provide a option like,do you really want to send, click "Allow" or else click "Deny" button.
Like below one.
Solution:
To ignore this problem instead of the ".Send" method in you macro use.Display Application.sendkeys "%s"
It will show original message for a second and then it will go without any prompt message as above.
Note:
Pros of Sendkys:
It will work on any applications you are trying to automate. Say for example if you are automating Skype and you want to send any text to type automatically, can use SendKeys here.Ex: application.sendkeys "Hi"
Complete list Sendkeys list here
Cons of Sendkys:
The only problem using the SendKeys is, at the time it performs to the specific applications/mail items should be active. Otherwise SendKeys will work on the other applications whichever is active.Other Scenario's you get prompt message
Except the .Send method, we have other scenario's wherein Outlook prompt message like "Allow" or "Deny".- Accessing/Extracting Recipients Details
- Accessing/Extracting Body of the Mail Details
as mentioned above scenario's you are able avoid using the Third party applications/Addins if your firm ready provide access over it. Please refer the below sites for your reference. Through which you can completely eradicate this problem. There is no other way other than this from my knowledge.
Thanks for visit.