The campaign has a multiselect picklist for Sales Theater (Values = AMER, APAC, PBST, Global etc) and wants to send an email alert to corresponding Distro List.
Examples below:
1. Selected picklist value is APAC, only send email to APAC distro list.
2. Selected picklist values = AMER, APAC, PBST, then the email alert should be sent out to all 3 DL's.
How can I achieve this without creating one workflow for each picklist value? Please advise.
In terms of ease of use, you could use one process builder with a criteria for each scenario. All your criteria in one location:
No matter what, you're going to have to have different email alerts for each specific distribution if using workflow/process builder. It also gives you the ability to potentially have language specific templates for each distro too if that's important. No way around separate email alerts unless you want to code something (or maybe use flow) and create a custom metadata type for a mapping of picklist to distros to dynamically populate the to address.
