When I am deactivating a user I get a warning to say that they are included in email alerts and so cannot be deactivated. However, as I have hundreds of email alerts set-up, it is not practical to go through each one manually to find the offending alert/s. Additionally it is not possible to display the recipient of the alert in the email alerts list view. Therefore i need to be able to query or report on the email alert object to find this information. How can I report on email alerts and show the recipient value for the alert.

  • Have you found a solution for this?
    – Avinash
    Sep 16 '16 at 18:42
  • I don't believe I ever found a solution for that one, sorry!
    – Bartley
    Sep 17 '16 at 5:59
  • You can use Force.com IDE to find out specific email alerts. 1. Create a new force.com project 2. Add all the email alerts to the project and save. 3. Open the Object.workflow source component (it will be in XML format). 4. Use normal Ctrl + F, find option, to search user names and then, check the associated email alerts.
    – Reddy
    Mar 23 '18 at 11:35

You could do this by searching your workflows metadata. For example in an Eclipse project you could use the file search functionality to search for the user email in all the *.workflow files in your current project.


You can use Tooling API for this and query the WorkFlowAlert table from developer console:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.