Email Templates

From Accelerator for SageCRM
Revision as of 17:37, 28 August 2020 by Sagecrmw (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Email Templates use data ONLY from the view contained in the settings

 entity_mailmergeview

EG

 <add key="cases_mailmergeview" value="vCRMTogetherCase"/>



You can control the SQL used to query the database (a setting in custompages/sagecrmws/web.config)

      <add key="getEMailTemplatesSQL" value="select emte_id, emte_name, emte_comm_from, emte_comm_replyto, emte_comm_note,emte_comm_email, emte_to, emte_cc, emte_bcc from emailtemplates WITH (NOLOCK) where emte_deleted is null order by emte_name asc" />