E Mail from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
DoCmd.SendObject , , ,"(e-mail address removed)", "(e-mail address removed)", "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.
 
Back
Top