I'd start by confirming that the recordset returns results after the submit. Your email code appears correct to me, but it is hard to spot problems without actively debugging. Have you dumped the session to see if the email code looks correct there?
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.