0

I am trying to find a way to send recurring emails every week, month, year, etc. which contains MySQL Query Results. My queries are related to total revenues, and I would love these queries to be executed automatically, and sent via email automatically. I am open to any program or language or advice in which direction I should look to get this completed.

Bijan Parvin
  • 21
  • 3
  • There's nothing in MySQL that sends mail, AFAIK. You'll need to write a script in some other language, like PHP or Python. It can perform the MySQL query and then send mail. – Barmar Jun 04 '19 at 00:28
  • PHP has a built-in `mail()` function, there's also a library called `PHPMailer` you can install. Python has `smtplib`. – Barmar Jun 04 '19 at 00:29
  • I'm sure you can find tutorials on how to use any of these things. SO is not a tutoring service. – Barmar Jun 04 '19 at 00:29
  • Possible duplicate of [sending email periodically through php script](https://stackoverflow.com/questions/23395506/sending-email-periodically-through-php-script) – danblack Jun 04 '19 at 03:54

0 Answers0