Set Mass Report recipients based ona text field in the Mass Recipient Report (comma separated emails).
Right now the mass recipient report in a scheduled report can only go to a single contact/user/lead per line of the mass recipient report. Instead, I'd like to merge a column from the mass recipient report which consists of a list of emails, maybe into the Additional To: or CC: field, like you can do with Dynamic Addresses & the field tagger in the regular DDP.
Without this, to send a single report to emails stored on our 180 chapters (custom objects), I either need to maintain 180 distribution lists and create contact records for them, or maintain 180 Scheduled Report DDPs where I hardcode the recipients and any passed values that would have been passed as !param# on the mass recipient report (and repeat for each kind of report I want to send).
Reports don't always get sent to contacts/leads/users and the passed !param that need to be sent aren't always related to a contact record, so this would give more flexibility to use the mass report and mass recipient list with custom objects.
Hello! We are taking the time to go through these ideas carefully so that we can inform our product roadmap. We'd love any help you can provide! Please feel free to add comments or votes at this time that will help us understand if this concern is still relevant to you, and if so, how we may improve your customer experience. Thank you!