Sending email to multiple people at once

  • Thread starter Thread starter ILIRI
  • Start date Start date
I

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
 
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
 
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
 
Back
Top