Please go through the below document and refer to the sample email (Example 6) relevant to this use case.
Creating and Managing Email Templates (saviyntcloud.com)
Example 6: Email to list all the managers and the details of their sub-ordinates. Manager receives a single email with the details of all the sub-ordinates.
To group emails by users, go to Admin > Global Configurations > Analytics and select Group Analytics Emails by Username .
To:
${userEmail}
Body:
Hi ${ANALYTICSDATA.MANAGER[0]},
Please find the monthly report of the details of all your reportees.
<table>
<tr>
<th>Reportee ID</th>
<th>Reportee Email</th>
<th>Title</th>
<th>City</th>
<th>Start Date</th>
</tr>
<% int count=Integer.parseInt("${ANALYTICSDATA.MANAGER.size()}"); for(int i=0;i<count;i=i+1){%>
<tr>
<td>${ANALYTICSDATA.'REPORTEE ID'[i]}</td>
<td>${ANALYTICSDATA.'REPORTEE EMAIL'[i]}</td>
<td>${ANALYTICSDATA.'TITLE'[i]}</td>
<td>${ANALYTICSDATA.'CITY'[i]}</td>
<td>${ANALYTICSDATA.'START DATE'[i]}</td>
</tr>
<% } %>
</table>
