function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sundar s 24sundar s 24 

how to report/query the recipients of email alerts

how to report/query the recipients of email alerts
VinayVinay (Salesforce Developers) 
Hi Sundar,

You can use Tooling API for this and query from developer console.

> Open Developer Console
> Click on Query Editor
> Check "Use Tooling API"
> Set query, e.g. SELECT Id, DeveloperName, Description, CcEmails, SenderType, TemplateId FROM WorkFlowAlert WHERE CcEmails like '%the.user@email.com%'
> Click Execute

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
sundar s 24sundar s 24
nice same way i want to get approver name from approver process i tried but it didnt workout 
Michael Foster 5Michael Foster 5
I need to extract the recipient's email address for each alert. What would be the query for that?
Richard Fiekowsky 3Richard Fiekowsky 3
@Michael Foster 5
 SELECT DeveloperName, CCemails, otherFieldAsNeeded FROM WorkFlowAlert 
Note that there can be multiple recipients, and, other types of recipients,  such as the record Owner, a public Group, etc etc, so a single query is probably impossible.