Hi @Dheeru
I think the best way is set an alert.
define your alert search and when you select your alert action > send mail and define attach csv.
anyway if you wuold send mail directly on your search bar you need this comand
sendmail
here the documentation
https://docs.splunk.com/Documentation/Splunk/8.1.3/SearchReference/Sendemail
Ale