I saw the below post which comes close to what I want to achieve. However, I want to send the entire Query List (10 columns) out as an email.
I tried a Query List and Send Notification only as part of my workflow. The Query List when I execute it retrieves all 5 of my records as expected. However, the email only displays one item from the list. I have spent 2 hours researching this and it appears I may need to create a Collection variable, however I am very confused on why this is required ? Do I need to create 10 Collection variables for my 10 columns...One post suggested a For Each, but what is the purpose of a For Each when I do not want to send out an email for each list item.
I use Nintex with SharePoint 2013 Enterprise.