Recordset Data in Email Templates

I have a recordset on the page where the Universal Email server behavior resides ($rsProps). I want to use data from that recordset in the email template that Universal Email uses (Blank_2.php). I have followed the advice of previous threads with no luck.

It seems that it all hinges on defining the recordset variable scope as global.

What is the proper procedure?

1. My recordset is rsProps
2. The Universal Email behavior resides on the same page as rsProps
3. My email template is Blank_2.php
3. I have added both "global $row_rsProps" and "global $rsProps" to the top of Blank_2.php with no luck getting the data to show when the email is sent

What am I doing wrong?

send a copy of your page please, and a copy of the Blank_2.php
template file so I can examine the code.

Thanks for the replay!

I've attached the files you requested. The "Blank_2.php" email template is very simple and based on the default layout. I was just trying to get something to work. Ultimately I would like "Blank_2.php" to use a repeat region for "rsProps" and also include data from two additional recordsets that are used in teaser_create.php (rsAgent, rsAgent2).

Basically, "teaser_create.php" displays a preview of the email I would like to send. It uses 3 recordsets - rsProps, rsAgent, rsAgent2. My goal is to have "Blank_2.php" send an email identical to what is displayed on "teaser_create.php".

Since you are looking to create a more complex email, I recomend not using the template.

instead, unselect the Create a file for the email option, then click the DW edit button to open a new tempalte that you can use to design the email body in dreamweaver.

In the bindings panel, you will have access to the recordset binfdings that you can add to your email message.