sending e-mail with Excel macro

[Mihkel]

I want to send e-mails automatically with Excel's macro,
but Outlook asks me each time before sending the e-mail
whether I want to allow Excel to send it on my behalf.
How can I skip this security procedure, so that no human
interaction is required?

 

[Ed Bennett]

After managing to set up OE-QuoteFix on his new PC, Ed reads a message

I want to send e-mails automatically with Excel's macro,
but Outlook asks me each time before sending the e-mail
whether I want to allow Excel to send it on my behalf.
How can I skip this security procedure, so that no human
interaction is required?

You'll probably have to reduce the security settings in Outlook.
But I would ask this question in an Outlook group. You'll probably get a
more accurate response.

 

[Epona]

I want to send e-mails automatically with Excel's macro,
but Outlook asks me each time before sending the e-mail
whether I want to allow Excel to send it on my behalf.
How can I skip this security procedure, so that no human
interaction is required?

And what in Hades has this to do with Publisher?! Do you ever bother to
check the group topic before posting?