Sending email based on SQL query
Hi,
I was wondering if there was support somewhere in Zoho for sending emails based on results from an SQL query.
I have a query that returns all deliverables in a project that are late. I would want to send a reminder to all people responsible for these deliverables. Right now the solution is to look at the table and use external email, so I was curious about possible support for automation, either inside Reports or if you combine it with other Zoho parts.