Macro SendObject Email notification message

T

TJAC

I have a macro that contains the SendObject to send data to several people
every day. I have used the Windows Scheduler to kick this off automatically
each morning before I even arrive at work. The problem is, each morning I
have a message waiting for me to approve the email being sent. I would like
to disable this so it will automatically send the email without me pressing,
"Yes."
Is there a way to do this so when I arrive at work everyone will already
have the report in their Inbox?

Thanks!
 
M

Maurice

The warning comes from Outlook. To avoid clicking the yes-button you'd have
to use "Redemption". This is a reference you have to set in Access. The
redemption library however is not a standard and should be downloaded first.

Take a look here for some steps you can take...

http://www.outlookcode.com/article.aspx?ID=52

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top