How can I send e-mails from the email data I have on a table?

[Guest]

Is there a way that I can send an email to the email addresses I have on a
table in Access?

I work for a community college and would like to keep students informed of
new classes etc. I have designed an database with thier names, email
addresses and fields of interests. I can pull up thier data based on the
field of interest, but I can't figure out how to take thier email address in
the table and then easily insert them into the field TO; in an an email in
Outlook... ( I don't want to have to copy and paste them all...)

Any suggestions??

 

[Guest]

Long story. Start here in a Access Visual Basic Code.

DoCmd.SendObject , , ,me.email ,"Me.ccemail", "", "txtSubjectLine" ,
"txtMessageText", True, ""

Copy this into code replace me.email with "(e-mail address removed)" and try it.
Later build the "txtSubjectLine" and o"txtMessageTxt" into something more
sophisticated like:

Dim txtSubjectLine as String
txtSubjectLine = Me.FirstName & ", you are on the promotion list for xyz, so
we need a drug test within 7 days of " & Format(now(),"mm/dd/yyyy" & " to
give you further consideration for the position.