...

[jazsriel]

....

 

[Ranman256]

Make a Union query to combine all emails in a single list,
then cycle thru it to build the TO list.

 

[June7]

Open a recordset, loop recordset to build string of email addresses. A common topic. One example https://www.access-programmers.co.uk/forums/threads/vba-to-email-from-recordset.236074/

Why do you have 3 tables?

 

[June7]

That doesn't explain why splitting into 3 tables. Add fields in 1 table to categorize email 'sets' and apply filter criteria.

 

[June7]

Did you view the link in post 5?

 

[bastanu]

For the almost "static" CC one consider using a dLookup:
.cc =dLookup("ManagerEmail","tblSettings")

Cheers,