That is not what global does. You can never declare a database connection or recordset on one page and reference it on another.
Specifically in the email body page you can add a recordset from the main page to use in the body by declaring it on the top of the page like:
<?php
global $RecordsetName;
?>