Sending email to multiple people at once

[ILIRI]

Hi,
I am creating a database for managing students. I have stored in tables
e-mail addresses for all students. So far I have seen samples of forms for
emailing individual students, however I need to come up with a form that
would enable me to email multiple students at once with the same message
(Your exam on MS Access is postponed until next Monday or You can attend on
lectures for MS Access on...) . List of students with their emails would be
filtered through query (worst case scenario would involve 100 students on
the list). I don't know how to start solving this issue so has anyone been
faced with similar issues in the past so I could see a template?

Thank you
Iliri

 

[Clifford Bass]

Hi,

Just put them all into a string variable, separating each by a comma.
Then use that string variable as the parameter for your Bcc field in the
DoCmd.SendObject method.

Clifford Bass

 

[ILIRI]

Sorry I was away for few day's. I did read this reply however I was unable
to try it sooner. I have tried few queries however I can't come up with
putting all Student emails into single record. Can you please advice me
further on this matter?
thank you

 

[John W. Vinson]

Sorry I was away for few day's. I did read this reply however I was unable
to try it sooner. I have tried few queries however I can't come up with
putting all Student emails into single record. Can you please advice me
further on this matter?

See http://www.mvps.org/access/modules/mdl0004.htm

 

[ILIRI]

Thank you
I found a sample of almost what I want to achieve, at this location.

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm