Skip to main content
Question

How to send multiple records to one email?


These are some sample records generating through the One desktop plan. Finally, these results will send to the Responsible persons who can resolve these issues. So in this results, we have three issues assigned to two users, instead of sending two emails, how can we send one email to Mohit?

In the Send email step, we are using HTML. Please see the below code.

This is a sample email received.
 

 

anna.spakova
Ataccamer
Forum|alt.badge.img+3

Hi ​@vishnu,

thank you for your question. I would suggest to construct the body in Alter format/Column assigner step + Representative create before the Send mail step → you basically create the table line for each record (issue) and then using Representative creator you should be able to concatenate multiple records into one. 

I have only much simpler example where we were concatanating multiple DQ rules and their results into one issue description - each on one line:

But your case should work similar way, it might just require a bit of work to make sure you properly define the HTML body (esp. escaping special characters in the strings might be a bit tricky). But I don’t think there is any other way. 

Alternatively, if possible, there is a Send mail task in workflows that (AFAIK) allows attaching files → so you can generate the records into e.g. a CSV file and attach it into the email.

Please let me know if this helped.

Kind regards,

Anna


  • Data Voyager
  • July 3, 2025

Hi ​@anna.spakova 

Thank you for your response!

I have tried your approach, but I faced some issues to reach the desired output. However, I have used another approach. So my requirement was to combine entire row into one line and send those rows to corresponding email. This was achieved in two steps:

 

Created a Column in Alter Format step where I concatenated all the col with html tags.

Then using the Group Aggregator to concatenate rows and group by Email and put in a col called ‘table’. 

Then import the ‘table’ in the Send Email html body, so that the step will render those record as html scripts.

The final email template looks like this.

 

Final Plan.

Please let me know if you have any question.

Best Regards,

Vishnu Soman


anna.spakova
Ataccamer
Forum|alt.badge.img+3

Hi ​@vishnu ,

this is great! I am happy it works :) And thank you so much for sharing this with us, I am sure this will help a lot of others.

Have a great day!

Anna

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings