E Mail from Access

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can you send a std letter to e mail addressess from Access databas 1
Sky e-mail via outlook 2
E-mail Macro 2
E-mail one record 1
Send an e-mail from the e-mail address in a Form 1
Internal E-mail Time Stamps 1
Help with Access sending an e-mail 3
loss of history of e-mail addressess-microsoft outlook 2002 1

Top