Email without user intervention

[Drenda]

Not sure if anyone can help with the following

I have created a send object action in my database that After update sends an email to a predefined email address. When the action occurs outlook opens, sets up the email and waits for the user to click the email send button
Is there any way the send object action can automatically send the email without any intervention from the user?

Once again any help would be appreciated

 

[AKMonkeyboy]

There is a dll file you can replace to remove this nag screen (if memory serves me correctly) - I have it, but haven't used it for some time. Do a google for "cdo.dll".

Also there's a nifty program available that allows you to bypass Outlook alltogether for sending e-mail. Check out AddEmail from Traysoft - works well for sending mail directly from Access.

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

 

[matrixindicator]

Its a long time ago and I haven't my code. I remember there is a possibility to send a mail without a user intervention. One possibility is a property set on your sendobject just before sending. If you get not an answer in the meantime I looked it up this evening.

 

[jadams0173]

Try doing a search for Outlook Object Model Guard. I use ASPEmail.dll a lot to do email tasks. It's free and works great.

 

[genomon]

Here is what I did: Downloaded and registered cdo 1.2.1 to C:\Program Files\Common Files\System\Mapi\1033\cdo.dll;
earlier release without popup security dialogs (newer is cdo 1.2.1s). Available at MSKB.

Money can't buy happiness -- but somehow it's more comfortable to cry in a Corvette than in a Yugo.

 

[matrixindicator]

A mail can be send without a user intervention. Perhaps Outlook should be open, but won't require a confirmation or action of the user.

[URL unfurl="true"]http://www.databasedev.co.uk/sendobject.html[/URL]

Edit False (0) is used when the message is not to be edited !

DoCmd.SendObject acSendTable, "emp_mast", acFormatXLS, , _
                 "smehra69@hotmail.com", , "Bank payment", , False

This mail is not opened for editing.