Formatting a list to be included within an email.

Multiple ways to do this, I use an Aggregator to merge multiple rows into one.

I am not sure the aggregator will work as I am wanting to include the list of items in the final email. Could the aggregator still achieve this list?

Not sure if I understand what you mean, but I think yes. You can always use Group By to keep original attributes. Attached workbench demonstrating this.

You should be able to create a html table with the HTML Report Generator which can be included within the email

True, but I then you need to create the entire email body in the HTMLReportGenerator, not the table only.

Nice thanks, learned something new today. :)

+1 for the HTMLReportGenerator way.

Thanks heaps for the reply, this did work for me!

Thanks again for the suggestion provided, it is working great.

I am just wondering if there is a simple way for me to add a header row to my HTML table, for inclusion in my final email?

The above solution you provided generates output that looks like the following, you will note it does not have any column headers. I am trying to work out how to add these but I am not having much luck!

This is the current configuration, as you can see there is only one "column name" field to populate, so its not really set up for this exact situation.