You can add the recordset to the page where the email server behavior is applied.
To access and use it in the email body you just have to add code to the top of the page like:
<?php
global $Recordset1;
?>
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.