Murray Brown
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Autohotkey can be programmed to click it for you (and it's so fast you won't even see it).
ASKER
What is Autohotkey. Is that free
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much
ASKER
Hi
I have posed a further question on this subject
https://www.experts-exchange.com/questions/28408602/Excel-VBA-using-Autohotkey-app-with-Outlook-mail-send.html
I have posed a further question on this subject
https://www.experts-exchange.com/questions/28408602/Excel-VBA-using-Autohotkey-app-with-Outlook-mail-send.html