Turn off email prompt during macro

[Guest]

I have a scheduled task to run in access which runs a macro and sends out an
email, everything works fine except when it gets to the email sending stage,
I get a promt to make sure I want to send the email. I would like to have
this go away so the process can go forward without any interaction.

Any help?

 

[Brian Tillman]

I have a scheduled task to run in access which runs a macro and sends
out an email, everything works fine except when it gets to the email
sending stage, I get a promt to make sure I want to send the email.
I would like to have this go away so the process can go forward
without any interaction.

Here are your options with respect to the Outlook Object Model Guard:
http://www.slipstick.com/outlook/esecup.htm#autosec
http://www.outlookcode.com/article.aspx?id=52