Trigger emails based on recordset field value

Is it possible to trigger emails based on the value of a recordset field value, rather than the submission of a form?

Use case is an email to go to people who haven't updated their details in the last month.

It might be the sort of thing that required a cron job, or maybe something that wasn't completely automatic but could be triggered by an admin submitting a simple form to trigger the emails, which is still a great timesaver compared to emailing people individually.

You can add a recordset to the page and filter based on whatever criteria you want so that only people that should be emailed are returned in the results. Then trigger off the recordset not empty and send to the recordset loop results.

A cron job is probably the best way to initiate the send rather than having to visit that page daily for it to send.

Thanks Ray. I'm not that familiar with cronjobs, but know where to add them in the site's cPanel, and the basic format of something like:

0, 9, *, *, * to run it every day at 9am, and the path to the script to run after that.

In this case, what would the path need to point to?

I'd just google: "cron job run php page" there should be a couple of techniques

I think what was throwing me was that there is a page with the SQL query and then the WA pages that control the sending of the emails.

But presumably any path would just need to be the original page with the SQL query that had the references to the other files.

That is correct. It would run just like manually visiting that page on regular intervals.