+ Start a Discussion
JBabuJBabu 

can we run reports on email template body field?

Hi,

I need to run report on the email body field?
It is has few merge fields.

Please let me know if we can run reports on this field? How?

Thanks,
Babu.
SlashApex (Luis Luciani)SlashApex (Luis Luciani)
Hi JBabu,

In short, no, you cannot run reports on setup items.

You can query EmailTemplates using Tooling API, but you will not be able to retrieve the Body.
If you want to run reports on the Email Template bodies, you will have to export all the email templates using the metadata API (force.com IDE) and parse through the XML. This would be relatively complicated.

Why are you looking to see the body field of the email templates? There might be another way to accomplish this.