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