David Fenton
dfe at nudgeeinternational.com
Mon Sep 1 18:48:05 CDT 2003
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