Send email from Access

[Simon]

I have a bit of VB Code that will send a customer a email and a report
attached

DoCmd.SendObject acReport, "rptCustomersNearDealersSearch",
"RichTextFormat(*.rtf)", Me.Email, "", "", "leads", "Please find
attached the latest customer brochure request for your area
", False, ""

When i run this works but it brings up a message tiemming me that a
prodgram is trying to send an email

It then makes be click Allow. when i click Allow it send the email

Is there a way to stop it bring up the message

I just want one button on the access form that will send the customer
an email with out a message coming up on screen

Thanks

Simon

 

[Douglas J. Steele]

Assuming you use Outlook for your e-mail, take a look at
http://www.slipstick.com/outlook/esecup.htm for why it's happening, and then
at http://www.dimastr.com/redemption/ for a common solution.

 

[Daniel Pineault]

Another viable approach would be to send your e-mail using CDO. See

http://www.paulsadowski.com/WSH/cdo.htm
http://www.worksrite.com/CDOMail.htm

Also, a site that discusses all the available Access e-mailing techniques see

http://www.granite.ab.ca/access/email.htm

See the 'Choosing a method of sending your email' section mid-way down.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.