E-mail from Access

[Nick]

This probably work better if I fill in the subject!!!

I have an automated/scheduled Access application from
which I want to send a status e-mail upon completion. I've
tried DoCmd.SendObject and the same thing via a macro. The
SendObject method pops up the e-mail and I have to click
Send. The macro tells me "an automated process wants to
send an e-mail" and I have to click OK. Can I make it
send automatically??

 

[Tony Toews]

This probably work better if I fill in the subject!!!

Agreed. We tend to ignore generic subjects.

I have an automated/scheduled Access application from
which I want to send a status e-mail upon completion. I've
tried DoCmd.SendObject and the same thing via a macro. The
SendObject method pops up the e-mail and I have to click
Send. The macro tells me "an automated process wants to
send an e-mail" and I have to click OK. Can I make it
send automatically??

This is part of the Microsoft's antivirus strategy. There are some
solutions and alternatives. See the Outlook section at the Access
Email FAQ at my website.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm