How To Generate Email to Person Specified in Combo Box and CC Persons in a Table or Query?

[Trace]

Hello! I have a form in which users will enter safety activities.



Based on the user's selection for "Initiator", the "Submit To" combo box (cboSupervisor) selects their supervisor, to whom the email should be sent once the "Send Email" button is clicked. The supervisor will be different depending on the user/initiator.

The row source for cboSupervisor is qryEmployeesandSupervisors, which is built from tblEmployees, and this table includes the supervisor emails.

Question 1 is: How do I get the supervisor email to be included into code for the email?

Question 2: I have a query listing all members of a Safety team that need to be cc'ed on the email. This list may change periodically as people join or leave the team, and it's based off a yes/no box in tblEmployees. How do I get these people to be cc'ed in the email?

Please let me know what if any additional information is needed and thanks in advance for helping!!

[Micron]

1) If the combo contains email address you can refer to it by column number (zero based, so second column number is one ( 1 ))

2) your email cc list query only returns the checkboxes that are checked, no? If so then I don't understand the question since that would mean those who have left are not included in the query results.

[Trace]

Hi Micron, and thanks for the reply.
The combo box DOESN'T contain the email address, just the supervisor's name, but based on this answer I could point to another column in the same table that the query is based on.

Yes, the query only returns "True" results, meaning personnel who are on that particular team. I'd like to know how to get that set of people included in the email CC.

[Micron]

Sounds like you'd need to loop over a recordset that contains email addresses
https://stackoverflow.com/questions/...ailored-emails