Sample Email Template

Knowledge Base
1

Hello,

I’ve been asked from time to time for a copy of the email template that I use in my ReportWORQ Demonstrations. This template contains a logo, title, date, 4 key metrics and 2 charts. We intend to one day have templates and a share template option built directly into ReportWORQ, however this HTML can be used right now. To use this template head to the email message editor menu system and choose Tools > Source code. Replace any HTML in that screen with the HTML below.

Since the HTML that you just pasted contains references to parameters, cell ranges and charts that do not exist in your job you’ll need to save, close and then re-open the job. Then click on each of the variable fields and adjust them to point to parameter, cell or chart of your choosing.

If you have a template you would like to share. Please follow the technique in this post or send the HTML to me and I will adjust and post the template.

Thank You,
-Andy

Email Template
Email Template713×400 22.3 KB

HTML Code for email template

<table style="border-collapse: collapse; width: 700px; border: 1px solid rgb(53, 152, 219); margin-left: auto; margin-right: auto;" border="1"><colgroup><col style="width: 699px;"></colgroup>
<tbody>
<tr>
<td style="border-width: 1px; border-color: rgb(53, 152, 219); padding: 5px;">
<table style="border-collapse: collapse; width: 100%; border: 0px none white;" border="1"><colgroup><col style="width: 26.1494%;"><col style="width: 73.8506%;"></colgroup>
<tbody>
<tr style="height: 127px;">
<td style="height: 127px; border-width: 0px; border-color: white;"><span style="color: rgb(52, 73, 94);"><strong><img src="https://reportworq.com/wp-content/uploads/2022/04/ReportWORQ-Logo-Square-FULL-COLOR-01.png" alt="" width="150" height="70"></strong></span></td>
<td style="height: 127px; border-width: 0px; border-color: white;">
<p>&nbsp;</p>
<p><strong style="color: rgb(96, 96, 96); font-family: calibri; font-size: 30px;">P&amp;L for&nbsp;<span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="Parameter" data-rw_parameter="Location" data-rw_isconfigured="True" data-rw_description="Location" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Location</span> </strong></p>
<p><span style="color: rgb(52, 73, 94); font-family: calibri; font-size: 12px;"><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="TimeStamp" data-rw_format="MMMM d yyyy" data-rw_isconfigured="True" data-rw_description="November 10 2022" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">November 10 2022</span></span></p>
</td>
</tr>
</tbody>
</table>
<p><span style="color: rgb(52, 73, 94);"><strong>Good morning,</strong></span></p>
<ul style="list-style-type: circle;">
<li style="line-height: 1.3;"><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelValue" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_range="RNGREVENUE" data-rw_isconfigured="True" data-rw_description="Cell RNGREVENUE" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Cell RNGREVENUE</span></li>
<li style="line-height: 1.3;"><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelValue" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_range="RNGINCREASE" data-rw_isconfigured="True" data-rw_description="Cell RNGINCREASE" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Cell RNGINCREASE</span></li>
<li style="line-height: 1.3;"><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelValue" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_range="RNGDECREASE" data-rw_isconfigured="True" data-rw_description="Cell RNGDECREASE" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Cell RNGDECREASE</span></li>
<li style="line-height: 1.3;"><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelValue" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_range="RNGEXPENSES" data-rw_isconfigured="True" data-rw_description="Cell RNGEXPENSES" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Cell RNGEXPENSES</span></li>
</ul>
<table style="border-collapse: collapse; width: 100%; height: 18px; border: 0px none white;" border="1"><colgroup><col style="width: 49.9659%;"><col style="width: 49.9659%;"></colgroup>
<tbody>
<tr style="height: 18px;">
<td style="text-align: center; border-width: 0px; height: 18px; border-color: white;">
<p><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelChart" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_chartname="ChartRevenue" data-rw_range="" data-rw_scale="80" data-rw_isconfigured="True" data-rw_description="Chart ChartRevenue" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Chart ChartRevenue</span></p>
<p>&nbsp;</p>
</td>
<td style="text-align: center; border-width: 0px; height: 18px; border-color: white;">
<p><span class="variable" contenteditable="false" draggable="true" data-rw_variabletype="ExcelChart" data-rw_reportid="bef69ddd156c4928b3c4f04f6d420ab8" data-rw_sheetid="c089b9e7df3f47d592776fd12e836688" data-rw_chartname="ChartExpenses" data-rw_range="" data-rw_scale="80" data-rw_isconfigured="True" data-rw_description="Chart ChartExpenses" data-rw_distribution_view_key="6f05a57b0cf24a8cbdd150b5518f8919638036838166100388">Chart ChartExpenses</span></p>
<p>&nbsp;</p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
1 Like