Any thoughts on a solution for mass emailing, using an email template, multiple case contacts (via contact roles or contact fields) from multiple cases? Each set of case contact role emails would be stored in relevant case email related list.
I was thinking of a processbuilder/flows solutions where the triggering action is when the campaign name field on the case record = the name of an email template.
Workflow would be configured to query and create variables against cased records, emailtemplate and campaign records, case contact role records. I was thinking of using the "send email" action as well. Does this make sense/is it doable? Is there any easier way of accomplishing this use case?