We are in the process of going multicompany in SF and separating company information by RecordType. Two of our companies have substantially similar business processes and the customizations we have in place for our parent company would largely apply to the new company.
We currently send an assortment of emails by using distribution lists in the Additional Email section of the Email Alert.
I'm wondering if there's a way to reuse the same Workflow Rules, Email Alerts and Email Templates by dynamically changing the Additional Email distribution list based on the RecordType of the Object.
We do have a custom Entity (Company) object where we could potentially store the appropriate distribution lists and reflect them on each Object with a formula field, but the Email Alert wouldn't recognize it as an Email Field.
Any thoughts or suggestions on this would be most welcome. Possibly the answer is that I need to suck it up and create an entire separate set of Workflow Rules/Email Alerts, but I'd prefer to avoid that if possible.