You can create a server event just before the email event and read the list into a process field.
Next, you would just need to drag the process field inside the message body.
I was looking for a no code solution if possible but looks like I will have to write code to do what I need. Thanks
You shouldn't need code, call the list method in the server event, then store it in a process field. Then just add the field to your email message body. I'm confused to why you would need to write custom code for this?
The list would need to be in a readable format. It has to be HTML formatted so that it makes sense. When you call the smartobject method you can only select one field to be returned. I dont understand what I am missing. Please explain as you see it.
Thanks