Improve company productivity with a Business Account.Sign Up

x
?
Solved

VBA Sending Mail through Outlook - Allow Access

Posted on 2014-04-08
6
Medium Priority
?
862 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:Murray Brown
  • 3
  • 2
6 Comments
 
LVL 28

Assisted Solution

by:omgang
omgang earned 800 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 37

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:Murray Brown
ID: 39988508
What is Autohotkey. Is that free
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
LVL 37

Accepted Solution

by:
Kimputer earned 1200 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:Murray Brown
ID: 39988797
Thanks very much
0
 

Author Comment

by:Murray Brown
ID: 39988874
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An Outlook data file aka PST is prone to corruption due to various reasons. A corrupt PST file is always inaccessible. Also, you may lose all your crucial mailbox content at any time. So to fix this corruption and protect the mailbox content from be…
Importing Outlook PST contacts to Exchange Server can become a complicated task. Situations arise where an Exchange user is not able to import contacts from PST to Exchange Mailboxes in an efficient manner. Try SysTools Exchange Import to move conta…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

584 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