E Mail from Access

T

Tom

I am designing in 2003 for a training company to manage it's course delegate
data. I need a routine/macro that sends e mail to the addressess of all
dlegates on a particular course. Delegates share a common course number.
Looking to lookup the email addersses from the access db of all delegates on
course x and address an e mail message to them
 
S

SacCourt

DoCmd.SendObject , , ,"[email protected]", "[email protected]", "txtSubjectLine",
"txtMessageText", True

You should look up in help SendObject.

Dim txtMessageText as String

Build the message based on fields in your database. Put in "toEmail" the
field for you emal in Access.
 
Top