Export of all email template details

[jpetralia]

Is it possible to export all email template details?

I did not see an obvious table in the schema, but am hoping to get this information.

The use case is we are hitting email rate limits with our provider and want to create DLs for each campaign template. I would like to provide the messaging team and export including at least Template Name and Recipients so we can quickly create DLs and then assign the DLs in place of the individual recipients for each template.

[rushikeshvartak]

select * from ecmemailtemplate--> to get all email details

[PremMahadikar · Accepted solution]

Hi @jpetralia ,

Below is the query to get all the details on email template:

select 
	NAME, 
	MAILBCC, 
	MAILCC, 
	CONTENTASHTML, 
	MAILFROM, 
	MAILSUBJECT, 
	TEMPLATECONTENT,
	MAILTO, 
	ISADVHTMLCSS 
from 
	ecmemailtemplate

If this helps your question, please select consider Accept As Solution and hit Kudos

[jpetralia]

Thank you @PremMahadikar This is a massive help!