....
J jazsriel Member Local time Yesterday, 22:24 Joined Dec 21, 2020 Messages 62 Apr 6, 2022 #1 .... Last edited: Apr 13, 2022
Ranman256 Well-known member Local time Yesterday, 23:24 Joined Apr 9, 2015 Messages 4,337 Apr 6, 2022 #2 Make a Union query to combine all emails in a single list, then cycle thru it to build the TO list.
June7 AWF VIP Local time Yesterday, 19:24 Joined Mar 9, 2014 Messages 5,490 Apr 6, 2022 #3 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?
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 AWF VIP Local time Yesterday, 19:24 Joined Mar 9, 2014 Messages 5,490 Apr 6, 2022 #4 That doesn't explain why splitting into 3 tables. Add fields in 1 table to categorize email 'sets' and apply filter criteria.
That doesn't explain why splitting into 3 tables. Add fields in 1 table to categorize email 'sets' and apply filter criteria.
June7 AWF VIP Local time Yesterday, 19:24 Joined Mar 9, 2014 Messages 5,490 Apr 8, 2022 #5 Did you view the link in post 5?
bastanu AWF VIP Local time Yesterday, 20:24 Joined Apr 13, 2010 Messages 1,402 Apr 8, 2022 #6 For the almost "static" CC one consider using a dLookup: .cc =dLookup("ManagerEmail","tblSettings") Cheers,
For the almost "static" CC one consider using a dLookup: .cc =dLookup("ManagerEmail","tblSettings") Cheers,