To automatically write and send email reports we need to have three tools:
A programming language. If the analysis is non-trivial, R is usually the best way forward.
An app that can automatically run the analyses at specified times. I’ve used Displayr. Of course, if you have the time you can avoid this commercial product and set up your own servers. (Disclaimer, I work for Displayr.) You can read this post to see how to get your data into Displayr and sign up to Displayr here if you do not already have an account.
An app to actually send the emails. I’ve chosen an email delivery application called SendGrid because R can work with its API.
To be honest, I’d probably use a different mechanism for deploying reports, but if you just need to put something together with a bit of chewing gum and bailing wire, the tools are there. H/T R-Bloggers