RE: Contact Emails based on role to customer record ONLY

I need a way to concatenate contact email addresses based on their role to the customer record. Right now, it will pull a contact email if they have the required role, but for a different customer record.
I have built a summary saved search to push the emails to the customer record, so we can utilize them for automated billing/shipping emails, but I can’t find a way to limit or expand the contact emails to JUST THE ROLE for the CUSTOMER RECORD.Example: I need emails for all contacts witht he Billing Contact role. Contact 1 and 2 are attached to Customer A. Contact 1 is Billing contact role and Contact 2 is Shipping contact role. BUT Contact 2 is Billing email for Customer B. With this scenario, both Contact 1 and 2’s email will show in the Billing Email Concatenated field for Customer A, since Contact B has a role of Billing contact, just not with Customer A.

JessicaBickis Rookie Asked on November 8, 2021 in Saved Searches.
Add Comment
2 Answers

Hi,

Could you please share some screenshots of your saved search?

Thanks,

Chris

Intermediate Answered on November 10, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.