Solved

VBA Sending Mail through Outlook - Allow Access

Posted on 2014-04-08
6
753 Views
Last Modified: 2014-04-09
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
Comment
Question by:murbro
  • 3
  • 2
6 Comments
 
LVL 28

Assisted Solution

by:omgang
omgang earned 200 total points
ID: 39986876
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
 
LVL 35

Expert Comment

by:Kimputer
ID: 39987038
Autohotkey can be programmed to click it for you (and it's so fast you won't even see it).
0
 

Author Comment

by:murbro
ID: 39988508
What is Autohotkey. Is that free
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 35

Accepted Solution

by:
Kimputer earned 300 total points
ID: 39988691
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
 

Author Closing Comment

by:murbro
ID: 39988797
Thanks very much
0
 

Author Comment

by:murbro
ID: 39988874
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now