Displaying Recordset Details in Email Body

Hi, I am trying to send email to multiple recipients. How do I get the first name (from recordset) of each recipient showing in their respective email. I tried the adding 'global recordsetname' at the top of the template but that is not working.

Recordset for the looping of the emails is $patrolUsers;
Emails are sent to $patrolUsers->getColumnVal("email") column from the database

I want to also show $patrolUsers->getColumnVal("fname") in the body of the email that is sent out.

Note: I am using the latest version of Data Assist.

Any help will do.

Thanks

Adding the global should work. Please attach the files and I can see if I can spot the problem.

Please see the attached. Thanks

Your global declaration looks like:

<?php;

global $patrolUsers;

global $memfullName

?>

it should be:

<?php

global $patrolUsers, $memfullName;

?>

If that still doesn't work, then I'd have to debug it live with FTP access to see why.

Thanks for the fast response :) but is not working.

Unfortunately I can't give ftp details as this is on a company's internal local server.

Please is it possible to get like a sample file that is working so I can model my code after that?

Thanks for the help.

I really need to debug it... Can we do screen sharing?

Please see PM for details.

Thank you very much

How can I browse to the page and send a test email?

Please see pm

Hi,
Please see pm. Thanks