Outlook Security when sending mail using VB

[jimbob2002]

Hi,

I have set up an automated email linked to my access database and everything works fine until the email is sent. Then I am presented with a pop up security box which stops my automated process. I have checked the forums and cannot see a way of bypassing this protection without using other utilities/software, can anybody help me?

Cheers,

Jimbob

 

[mp9]

One method to try might be adding a VBA reference to an MS CDO library and then using CDONTS to send the e-mail rather than Outlook, with code somehting like:

Dim oEMail As New CDONTS.EMail

oEMail.From "anyname@anydomain.com"
oEMail.To "youremail@yourdomain.com"
oEMail.BodyFormat = CdoBodyFormatText
oEMail.Body = "Insert some useful text here"
oEMail.Importance = CdoHigh
oEMail.AttachFile "C:\filename.txt"
oEMail.Send

Another is to use Outlook Redemption, available from

http://www.dimastr.com/redemption

- yes, it's a third party external utility but it does exactly what you want whilst still allowing the mail to be send from/by Outlook.

Hope this helps.

http://www22.brinkster.com/accessory/