Populate mail template from recordset
I am building a real-estate marketing tool with messaging system allowing buyers to notify their interest to the seller.
Buyers and Sellers will be registered and logged in for this functionality.
So, a buyer clicks on a property and a form loads for the buyer to submit their interest.
A recordset checks the sellers email preference and if true, triggers UE4 to send my custom email template to the seller with a notification of the buyers interest.
I have another recordset that pulls the sellers property detail and maps to the buyers contact info - which is where i want to take my content from dynamically.
I'm struggling to work out how best to populate my email template with this recordsets data?
My UE4 server behavior in my 'expressions' page contains;
$EmailRef = "waue_interest-confirmation_1";
and in the that file ("waue_interest-confirmation_1.php") i have;
$MailBody = $MailBody . (GetFromPage("../../email/templates/html/eoi-notification.php"));
which points to my custom .php email template, which is where i want to populate with detail from recordset.
Does anyone have any advice please?