How to automate report generation and email?

How to automate report generation and email?

I would like to have a sales tax liability report run the 1st of every month and emailed to me.

(I would also like this report to have a total amount for each column, not just the total sales tax collected, but apparently that's not possible.....)