Sending recordset data in universal email body

I have a query on a page with universal email. Universal email is using the email address of the recordset to send emails out. This is working.

However, whenever I add fields to the email template from the recordset, the emails won't send. Do I also need to include the recordset on the template page of the email? I can't find a tutorial for adding recordset fields to the email template.

Thank you.

I found this in another thread, and it seems to be working now.

<?php global $recordset_name; ?>

Actually, it's not working. It's only sending the first record in the recordset, not all of them. Please see PM and attachments.

Thank you.

Your getIssuances recordset is only returning one row.... update this line:

$getIssuances = new WA_MySQLi_RS("getIssuances",$numeroseti,1);

to:

$getIssuances = new WA_MySQLi_RS("getIssuances",$numeroseti,0);

Then it will return all rows.

Thank you!