close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Getting dynamic Recordset data into the email body

Thread began 1/28/2011 9:12 am by ryanteets270615 | Last modified 1/31/2011 7:32 am by Jason Byrnes | 2758 views | 4 replies |

ryanteets270615

Getting dynamic Recordset data into the email body

I have read through all the posts here about other people having similar issues, but I just don't understand the advice that is suggested. Can you please clarify this for me?

I'm using Universal Email 3.0.7 and I have a PHP page with a recordset that gets a list of customers (id, email) and repeats region in a table (so I can pull 100 at a time) and send the email to those people. The UE TO field is set to the recordset customer email:

//WA Universal Email object="mail"
//Send Loop Once Per Entry
$RecipientEmail = "".$row_WADAsamples['email'] ."";include("WA_Universal_Email/WAUE_email_customers.php");

This is fine. Now, in my email message body I want to include a link that includes each customer's dynamic data for id and email like this:

<a href="http://www.site.com/index.php?email=<?php echo $row_WADAsamples['email']; ?>&id=<?php echo $row_WADAsamples['id']; ?>">click this link</a>

Right now this link displays only the first recordset item's data on every mail that is sent out. Can you please explain what code I need to include (and where) to make this link in the mail body receive the correct recordset information for each entry that is sent?

It is very confusing trying to determine this from the other posts. Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of your page and the WA_Universal Email folder so i can look at the code.

Sign in to reply to this post

ryanteets270615

files

Here are my files you requested.

The UE will only send to the first recordset item, not all of them. However If I change the repeat region to display one record at a time, and then page over to the second or third page, it does send the correct email and id in the email body.

Somehow the looping feature does not seem to be working (at all now) and when it did, it sent the same info in every email.

Let me know if you are able to find something in these files.

Attached Files
ryanteets.zip
Sign in to reply to this post

ryanteets270615

upgraded to UE4

I made the upgrade to see if this would help. After updating the server behavior, I realized that in my previous TO: field I did not choose the recordset loop but rather the once entered. So, correcting that does make it send to each person correctly.

However, it still displays the first recordset field data in the email body (the same for all recipients).

Is there an easy fix for that??
I'll check the other board posts again.
Thanks!
Ryan

Sign in to reply to this post

Jason ByrnesWebAssist

see this thread for details on fixing this:
showthread.php?t=17869

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...