You would have to code it by hand... Are you referring to any of the data from the recordset in the body of the email or just using it for the list?
Please attach a sample page and I can help you edit it.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.