ActiveWorkbook.SendMail brings up warning

[Joe S.]

I'm trying to automate a few Excel files to automatically
email out. I'm doing this within the Excel macro using
the ActiveWorkbook.SendMail vb command.

The problem I'm running into is that when the macro
generates the email, I get a warning saying that Excel is
trying to automatically send an email, and asks if I want
to send it. I must 5 seconds before I say "yes."

Is there a way to disable this warning? I really need to
automate this spreadsheet so I can take vacation days.

Thanks,
Joe

 

[Eric Legault [MVP - Outlook]]

This behaviour is by design. See this page for full details:

http://www.slipstick.com/outlook/esecup.htm#autosec