Is there a way to have a nested recordset in an email
I have a page with a recordset that selects information about a supplier which loops through the records and displays then on the page. Within the loop I have a nested recordset that pulls the information (and also loops) based on the ID of the supplier in the previous recordset. This all works fine, however I need a way to email all of the information - the original looped recordset and the nested looped recordset.
Is there any way to do this?