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

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