Universal Email

I am using UE4 (universal email 4) to send a mass email via "once per entry from recordset" and with "wait 1 sec between emails, max of 200 per minute". However it is only sending once to the very first email in the list. Never to any of the other emails.

Attached are screenshots and code. Currently my list only has 4 or 5 emails (all mine). But I only get an email delivered to the very first email in the list. Can anyone tell me what may be going wrong.


Thanks - Dan

Using DW CS5 / Mac OS 10.6.4 / UE4 Super Suite

Hi Dan,

One thing I noticed at line 45 - the exact same query is executed three times in a row. This would most likely cause a problem.

Regards,

Brian

Brian,

I have removed the duplicate recordset code, but the problem persists. It still only sends to the first email in the recordset.

Attached is my revised code.

BTW - I am using CS5 Dreamweaver and the latest extension. Dreamweaver CS5 duplicates the rs code anytime you open the rs in the bindings panel. Bug in DW.

Any further help is appreciated. Thanks. Dan

in the webassist/email/waue_index_4.php file, instead of referring to the recordset columns as

$row_rsSubscribers['ColumnName']

Use this syntax instead:

$RecipArray[$RecipIndex][0]['ColumnName']

Brian,

I tried as you suggested, but $row_rsSubscribers['ColumnName'] does not occur in webassist/email/waue_index_4.php

I have attached my file webassist/email/waue_index_4.php (sorry, i should have posted that earlier) for your reference.

There was one instance of $row_rsSubscribers['ColumnName'] in the file (index.php) that contains the form and server behavior for UE. So I tried to replace that piece of code, but it did not fix the problem.

Any further suggestions/help is very much appreciated!!!

Thanks -Dan

I'm sorry the rs subscrtibers recordset is not used in the email, a different recordset is. the advice given previously wont apply, sorry for that.


Can you double click the RS recordset and send a screen shot showing the reordset settings, then click the test button and send a screen shot showing the results please.

Jason,

Attached are screen shots as requested. Thank you!

hmmm, so the rs is returning three results, so it will try and send to all three emails, I would suspect something on the SMTP server is preventing the email from being sent to the the other two addresses, Contact the hosting provider and see if they can look in the SMTP server error logs to see why the message is not being relayed for the other two addresses.

Jason,

I spoke to my mail server tech support, and they checked the mail server smtp logs. The mail server error logs only show attempts to send to the first email in the recordset. Nothing for the subsequent emails in the recordset.

They said this indicates that the script's loop is not repeating.

Does this help? Any suggestions?

Thanks again for your help.
-Dan

Hmmmm, after the body tag add the following code:

<pre><?php var_dump($row_rsSubscribers); ?></pre>

this will show us the recordset contents on the server.