Richard: I have a form that uses a combobox to select a teacher, then on the subreport, all students to that teacher are displayed.  I want to be able to send an email to all email addresses in the student subform, any suggestions?

---

Reply from Richard Rost:

You will need to loop through all of those students with a recordset and send to them individually or put their addresses in a single string. I'll be covering this in my upcoming Email with Access Seminar. Stay tuned.