Solved

VBA Sending Mail through Outlook - Allow Access

Posted on 2014-04-08
6
759 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

911 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

21 Experts available now in Live!

Get 1:1 Help Now