How to send Email with Mapiex listing different variables in the Email body


New Member
I need to build a process in Blueprism to read and extract some fields from a given SQL Server 2016 table (employee names, tasks assigned to any of them, task deadlines, email addresses) and generate one email via MapiEx for every employee which contains, stictly in the email body, his name and the list of his assigned tasks expiring a certain given date [getdate()+7]. This is a scheduled process.
I can't find the way to create the list of all assigned tasks for every assegnee and "paste" it to the email body.
Could you help me?
Many thanks in advance, kind regards.