[AccessD] Sending emails from within ACC02 - Answer

To get rid of the security warning message
One way is to use the redemption dll
http://www.dimastr.com/redemption/

David Fenton wrote:

>Sorry folks,
>Just found a site that answers my own question
>http://www.granite.ab.ca/access/sendobject.htm
>Cheers,
>David
>Brisbane
>Australia
>
>
>Just wondering why I would use the following code
>http://p2p.wrox.com/archive/vba_access/2002-04/1.asp
>
>...instead of what I'm using successfully right now (in a loop)
>DoCmd.SendObject acSendNoObject, "", "", strEmail, , , strSubject, strMsg, False
>
>Both seem to do the job, but my way is only one line of code, the other requires an entire module to be set up.
>
>Am I missing something? Or has Access improved to the point that the automation code shown on the above website is simple legacy now?
>
>However I do need a hand to switch the warning message off. The message says "A program is trying to send email on your behalf... etc etc"  
>
>The usual DoCmd.Setwarning does not stop it from appearing
>
>Cheers 
>David Ô¿Ô¬ 
>Ext 0751 
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>