Hi all,
I have a database with information about the instructional staff in my school (Instructors, Teaching Assistants, Readers). They teach different types of classes (math, composition, general education).
I have a juncture table to assign a role to each individual. It links Course, Person, and Role (Instructors, TAs, Readers).
I would like to create a form that has a few command buttons that will each allow sending an e-mail message to a group of instructors, such as all instructors who teach math, all TAs, all instructors who teach composition, etc.)
I believe that I will first have to create a query that filters the appropriate individuals and pulls their e-mail addresses.
But how do I set up the VBA code to compose messages to all of those people?
I would like to click a button in the form and make all of the addresses from the query go to the bcc field. I would like the form to have several such buttons, for each of the groups mentioned above.
I do not need a form letter or attachments.
I just need to be able to click a button and have a new Outlook message populate with the relevant addresses in the bcc field.
Any help would be appreciated.
Thanks!