close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Universal Email not looping through recordset, and only sending one email

Thread begun 9/17/2013 7:19 am by sandy170299 | Last modified 9/17/2013 9:25 am by Jason Byrnes | 4197 views | 8 replies |

sandy170299

Universal Email not looping through recordset, and only sending one email

I have already tested the query directly in my MySQL database, and it's working just fine - it's just not looping once the emails are sent. Thank you.

Sign in to reply to this post

sandy170299

FYI, it doesn't make any difference if I wrap the output query in a repeat region or not.

Sign in to reply to this post

Jason ByrnesWebAssist

The way you have it set up, it will not loop through the recordset. To set up a recordset loop, click the "To" button to open the advanced to settings.

In the advanced to settings, add a new address, for the type, select recordset loop, select the recordset and the email address column.

see the attached screen shots.

Sign in to reply to this post

sandy170299

Thanks! Then there should be no repeat region on the DW email template page?

Sign in to reply to this post

Jason ByrnesWebAssist

not unless you want to loop through the recordset within the email body.

Sign in to reply to this post

sandy170299

Thank you!!! It's working now!

Sign in to reply to this post

sandy170299

Actually, I have a query filtering out what should be five email addresses, and it's only sending to 4 of the 5. ??? This is happening consistently. Sorry!

Sign in to reply to this post

sandy170299

Okay ... now it's working, for some reason. I have no explanation, but will let you know if it continues to shorten the list. Thank you!

Sign in to reply to this post

Jason ByrnesWebAssist

Does it redirect to another page after sending the email?

Add the following code to the page it goes to after sending the email:

php:
<?php @session_start(); var_dump($_SESSION); ?>




This will write the session contents to the page, one of the session variables will show a status message for sending to each address. If this shows Success for all 5 addresses, then it is an issue with the SMTP Server not relaying the email for the address that is not receiving it.

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