ActiveWorkbook.SendMail brings up warning

  • Thread starter Thread starter Joe S.
  • Start date Start date
J

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
 
Back
Top