Thread
:
Can I avoid the warning when I send mail from Excel
View Single Post
#
2
May 7th 07, 06:37 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
Posts: 11,651
Can I avoid the warning when I send mail from Excel
See
http://www.outlookcode.com/d/sec.htm
for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions. Your Outlook version is a critical factor, so be sure to include it when you post here.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"CH-DE-FDS APRIL" CH-DE-FDS
wrote in message ...
I have set up a Macro to send different views of a Pivot Table to different
people.
as follows:
"
ActiveWorkbook.SendMail Recipients:="A.N.Other", Subject:="TEXT FOR
RECEIVER"
ReturnWhenDone = True
"
When the Macro accesses Outlook it throws up a warning on screen Saying
"
A program is rying to automatically send Email on your behalf.
Do you want to allow this?
Y / N
"
How can I avoid this warning?
With one or two addresses its not a problem but with 50+ its time consuming
to have to wait and then reply YES!
Thanks for your help
Sue Mosher [MVP-Outlook]
View Public Profile
View message headers
Find all posts by Sue Mosher [MVP-Outlook]
Find all threads started by Sue Mosher [MVP-Outlook]
Ads