Insert record, send email to email address not on form?
Hi, I have a DA created page which collects client information and assign it to a staff member which has been selected from a dynamic drop down. Is there any way I can get UE to email this staff member with the record details?
For example, from the staff member menu list, I select 'John Smith', this stores his ContactID in the table. I need UE to then email John Smith with the insert record details but his email address isnt available in session.
It does exist in the recordset ie; Name: John Smith, ContactID: 100, Email: email@example.com so inside UE I selected that field from a recordset but its doesnt work, probably as it doesnt know which email I need? <?php echo $row_WADADynListtblAdvisor['ContactEmail']; ?>
Any ideas how I would grab the email address for the inserted record?