[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

VBA Sending Mail through Outlook - Allow Access

Hi

I am using Excel VBA to send messages through Outlook
If I use Msg.Display where Msg is My mail item it seems to work faster
than using Msg.Send because a message pops asking if I want to Allow Access.
I have over 200 messages to send at a time so is there a way to have that message pop
up once for all my messages
0
Murray Brown
Asked:
Murray Brown
  • 3
  • 2
2 Solutions
 
omgangCommented:
Not natively.  Using a third-party tool it can be done.  I've used, and been happy with, Outlook Redemption.   http://www.dimastr.com/redemption/home.htm

OM Gang
0
 
KimputerCommented:
Autohotkey can be programmed to click it for you (and it's so fast you won't even see it).
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
What is Autohotkey. Is that free
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
KimputerCommented:
Yes Autohotkey is free. It runs in the background, but it's very light, you won't notice it's there. You program it to detect only that specific Outlook warning, and let it click Yes.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now