We can do this by replacing the placeholder in the mail body.
First we need to read the CSV file using Read CSV activity, which will output a datatable (DT)
Create a string variable
template = "Name
FirstProductName
Price
FirstProductPrice
Discount
FirstProductDiscount"
create new variable
mailBody = "Hello,
The top 3 results for TV are,"
Then iterate on the datatable,
For each Row in DT
mailBody = mailBody+template;
mailBody = mailBody.Replace(“FirstProductName”,Row(0).tostring).Replace(“FirstProductPrice”,Row(1).tostring).Replace(“FirstProductDiscount”,Row(2).tostring);