I have recreated the issue I am having and it's definitely when I add the record-set to the email template that things start to go wrong. Once I do, it stops emailing. But if I put up the email template directly in the browser, I see the results of the record-set. For a while I was getting errors that suggested I was not connecting to the database correctly or that I had an undefined variable. However, I know that is not true because of my ability to see the page directly in the browser. What could be the problem?
I have even tried moving the email to a page (a payment page that the user is sent to after they register) that already has the record-set I need in it and not having it in the template (you seem to do this in the userregistrion solution for retrieving a lost password). The email sends but none of the data from the record-set is being emailed. Is there a solution where I can do this instead?