close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Need to pass user data into email body for multiple emails

Thread began 4/22/2010 10:50 pm by jerniganj377713 | Last modified 10/01/2010 4:25 pm by roby258376 | 1052 views | 8 replies |

jerniganj377713

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

jerniganj377713

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.

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

peter.gray299936

data from recordset not available in body

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

roby258376

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

Sign in to reply to this post

Jason ByrnesWebAssist

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


see my reply there.

Sign in to reply to this post

roby258376

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...