merca
Valued Contributor II

@Aleksandar Mirkovic​ I second that an example should be provided in documentation! (hint, hint @Kaniz Fatma​ ​ 😉 )

Here is an example how to add the QUERY_RESULT_ROWS in email: (query result is table with 2 columns: column1,column2)

<table>
<tr><th>column1 header</th><th>column2 header</th></tr>
{{#QUERY_RESULT_ROWS}}
<tr>
<td>{{column1}}</td> <td>{{column2}}</td>
</tr>
{{/QUERY_RESULT_ROWS}}
</table>

 note of caution: if a receiver have turned off html rendering in email, this does not look good!!! The tags will be written out as plain text