hi Dave,
do you know that it already exist !
You can go on your report :
then “email this dashboard” and you will be able to define recurring email !
I hope this helped you
Jimmy