add variables to from in Emails from triggers.
Allow variables in To field of Email triggers. Just like in the subject and body so email/email list to can be pulled from a table and not be static. You can use variables in the To field of an email for the datapage and it should also be in the email trigger action.
Tony S commented
You can use SELECT block and attach it to the TO/CC field. There must be the only single field returned by the SELECT statement - with emails. They will be concatenated into a single string and used for your email TO or CC.