Hi Sergey
I have moved on to the massmailer template and it is working great, just trying to read up on how to insert the selected records into the email.
I did read up on this article here, but it doesn't seem to indicate that you can use it within massmailer?
https://www.xlinesoft.com/phprunner/docs/email_selected_records.htm
Example:
I have a certificate of a learner that is going to expire in two days time (Still testing how to do month). This is the code I used:
select * from tblgenmach where genmachclient = "[Actual Company Name]" and DATEDIFF(GenMachDateIssue, now())=2
So basically, the query pulls the specific company and the learner whose certificate is expiring (Obviously we deal with hundreds of learners). How do I go about inserting the results of those learner's to the client in email format? I did read up on the attachment "How to attach a page from the project that is password protected?"
Am I over complicating this myself?
Kind Regards