Need to pass user data into email body for multiple emails

I am using Universal Email to send an email to all users in the database. I am trying to pass in information for each user into the body of the email. username/password.

Webassist creates a loop to send to all users in DB. How do i capture the username/password of each user pass that into the email body?

Thanks

If you are using the recordset loop for the email addresses you can use the bindings from this same recordset in the body of the email message. You can just drag and drop the bindings from the rs onto the page where you would like to see them.

Thanks Eric, i did try that, but no info from the DB is being pulled over.

here is the code from the loop that WA Universal Email created:
if ($RecipientEmail) {
$WA_MailObject = WAUE_AddRecipient($WA_MailObject,$RecipientEmail);
}
else {
//To Entries
do {
$WA_MailObject = WAUE_AddRecipient($WA_MailObject,"".$row_rs_members["emailAddress"] ."");
} while ($row_rs_members = mysql_fetch_assoc($rs_members));
}


And here i did what you said by adding the database field to the email body:
$MailBody = $MailBody . "password: ";
$MailBody = $MailBody . $row_rs_members['password'];

i have the recordset pulling in all fields with a asterisk. ANything else i should be doing? THanks.

Please post back with the page that has UE applied to it and a copy of your webassist folder from the site. I will take a look to see if I can spot the issue. I'm wondering if the include for the body needs to be moved within this loop.

I have also come across this problem.

The data in the recordset never changes from the 1st record, while the array used to insert the email addresses correctly advances. I've tried using the array itself, but the $CurIndex and $loopCount values are of no use - being incremented before the call to the included email body.

Experimentation has allowed me to send the email, but I can't reference the recordset directly - I have to use the array as : $RecipArray[$RecipIndex][0]['<fieldname>']

Also if the array is supposed to be how we access information from the recordset, then functions to provide access to these would be really helpfull!!


One of the great strengths of Universal Email has been it's ability to send emails based on a recordset and to have all the fields relevant to the email address available.

This seems to have temporarily disappeared completely with UE4 - such a pity!!

Regards

Peter Gray

Please explain a little about what you are trying to accomplish as an end result and what you have tried to get it to work. What recordsets do you have involved and how are you using them? Please post back with the details and include a copy of the page with UE on it as well as a copy of your webassist folder from your site so we can take a look.

I'm having the same problem. Any help would be appreciated, have wasted half a day already on this

you also posted in this thread:
showthread.php?t=15672


see my reply there.

Yup, I did, sorry for wasting your time, but I'm kind of under a time constraint here and not being able to find a single solution to this problem, even though I'm not alone in experiencing it, is frustrating.

Will upload the files you requested.