Emailing from Access

[MonkeyMagic]

I cannot see how to send emails from access to groups. I have lists of
students and their email addresses, but can only send individual emails so
far. I don't want to have to put all their addresses into Outlook if there is
another way.

 

[Daniel Pineault]

How are you sending e-mails from access? Using SendObject? Like most
e-mails programs you can specify multiple recipient by separating their
respective e-mail addresses by a ; Therefore you can concatenate their
e-mail addresses together with the ; and then use this new string as your
input variable to sendout your e-mail.

If you need further explanations, please explain a bit more the specifics of
your emailing process as it stand now and provide any code you are using so
we can help.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Arvin Meyer [MVP]]

I cannot see how to send emails from access to groups. I have lists of
students and their email addresses, but can only send individual emails so
far. I don't want to have to put all their addresses into Outlook if there
is
another way.

Here is a sample that shows how to send a report to multiple recipients:

http://www.datastrat.com/Download/EmailSenate2K.zip