Emails not sending if recipient is from database

Hi,

I'm having a few issues trying to get UE 4.01 to work as intended. Here's the issue I'm experiencing:

I have a filtered recordset displayed on 1 page and each result has a button that sends the user to the page with UE4 applied to it that requires the user to fill out their query and send an email to the specific recipient who's email is supplied from the database result (filtered by using POST method).

The data is being filtered correctly and the resulting email address is being echoed out to ensure the data is being pulled out from the DB.

However, the email is not sending to the recipient. If I remove the dynamic binding from UE4 and manually input the email address it works as expected, but not when using the bound data from the database. I've tested this using various email addresses that are both on the same server and offsite (gmail, hotmail, etc.)

No errors are being generated and I'm using the mail method.

Any suggestions as to why this would be the case?

Regards

Paul

Hi after reading this, in your description - dod you also mean that you have filtered the data on the same page as the universal email? Perhaps you could do a test where upon on the page with the universal email behaviour on - echo out the email address to show it on screen, then at least you know if the actual password field is available for use on that page since if it displays on the screen (on the universal email page) then you can use it.

Chris

Hi Chris,

The search results page filters the data based upon your search criteria and then when you click the 'Request a Callback' button, this sends the relevant ID via POST to the page that UE4 is being used.

I've set this page to output the name and email of the record to ensure that the data is being returned correctly (which it is), but the UE behaviour will not send it to the address if it is being pulled from the DB as opposed to manually inputting the email address in the UE interface.

Sorry for any confusion my orginal post may have caused :0)

Regards

Paul

Hmmm in the universal email window for the TO input box. does the dynamic code look somethign liek this:

<?php echo ((isset($_POST["email"]))?$_POST["email"]:""); ?>

(as thats how I got mine setup)

is your recordset code BEFORE the universal email code on the same page?

Chris

Hi Chris,

Yup, the DB is setup before the UE code and the following is used for the 'TO' email address:

<?php echo $row_rsCompany['fr_Email']; ?>

As this is pulled from the DB on the page, the code you used would be applicable if the email address was being sent via POST as opposed to pulled from the filtered database recordset, unless I'm way off base with it :0)

no your right so im stumped - Jason needs to look at your code. so you should put your php file into a zip file and then upload that file on this thread so that Jason can view it.

Chris

Cheers for the reply Chris, and I'll pop the file in a zip and upload it now. :0)

this is really a pretty simple problem, it has to do with data persistence.

page one has a form element on it named "id", it posts to the callback.php page and filters the recordset when it is loaded.

the problem is that the form on callback.php does not post the id when it triggers UE to send the email.

the solution is to add a hidden element named "id" to the callback.php form that captures the value sent in from the initial page:

<input name="id" type="hidden" id="id" value="<?php echo((isset($_POST["id"]))?$_POST["id"]:"") ?>" />

Hi Jason,

Thanks for the help, that worked a treat. However, it now includes the ID as an entry in the sent email as the hidden element needs to be in the form element and so gets included in the data printed in the email.

Is there any way to stop this happening?

Regards

Paul

Yup, in the email template file (look in the webassist/email/templates folder) edit the remove array near the top:

$remove = array();

$remove[]  = "";

$remove[]  = "x";

$remove[]  = "y";

and add the id element:

$remove = array();

$remove[]  = "";

$remove[]  = "x";

$remove[]  = "y";

$remove[]  = "id";