CronJob to send automatic custom CDR email

Linux_01 · February 3, 2021, 6:58am

dicko:

0 11 * * 2   mysql asteriskcdrdb  -H -e "SELECT * FROM cdr WHERE  calldate> CURDATE()- INTERVAL 1 WEEK AND  dst='911'"|mutt -e "set content_type=text/html" -s "911 calls for the last week" [email protected]

I am having mail command in the system and not mutt. Can not install mutt as I have to update the system for the same and I do not want to do that.
Can we achieve it using mail or mailx command