Install mutt
apt-get install mutt
example query
mysql --html -uroot -p mydb -e 'select month(timestamp) as "Month", day(timestamp) as "Day" ,count(*) from table1' | mutt -e "set content_type=text/html" -s 'Mysql daily report' user@email.org