Sending E-mail from Access (Full Automation)

[Dragenesis]

I need to fully automate the sending of an e-mail from within access. So far, I've used the .sendobject and outlook.application/outlook.mailitem/etc...

Both of those methods work, but the both give me a pop-up telling me that access wants access to outlook and I have to click "Yes" in order to have the e-mail sent. How do I get rid of or bypass that pop-up so that the e-mail will still send if I'm not around to click yes? I am not in a position to install additional software on the computer so will need to do this with just VB, Access, and Outlook.

 

[DJkarl]

I need to fully automate the sending of an e-mail from within access. So far, I've used the .sendobject and outlook.application/outlook.mailitem/etc...

Both of those methods work, but the both give me a pop-up telling me that access wants access to outlook and I have to click "Yes" in order to have the e-mail sent. How do I get rid of or bypass that pop-up so that the e-mail will still send if I'm not around to click yes? I am not in a position to install additional software on the computer so will need to do this with just VB, Access, and Outlook.

Have you tried searching the forum, this topic has been covered before, you can use the CDO method, or put code into Outlook itself then call that code from Access.

 

[CraigDolphin]

Just an FYI

Not to put too fine a point on it but not many folks here who might be able to answer your question are likely to do so if there's any suspicion that you might be using access to send spam emails.

Unless you're trying to use access as a means for sending spam without notifying the user of a computer where the db is installed, why is waiting for the user to click 'yes' such a burden?

I mention this because you appear to have limited access to the user's computer and want to hide notifications that emails are being sent by that computer.

 

[KeithG]

The message is a form of protection build into MS outlook. The only way to bypass the pop ups is to use the redemption.dll . Search for the file with google and Ill bet you can find a site to donwloand it from.

 

[Dragenesis]

The reason I don't want the user to have be there to click yes is that it the e-mail sent details things of interest to the higher ups and the info varies with the day. In order to have this sent, someone has to come in early to write the e-mail before others arrive and start working. This is to eliminate the need for a specific person to have to come in before everyone else just to write the e-mail. I'll search for the CDO method in this forum.