Following is an example (untested but you should find working examples on Splunk Answers) of using map command to get email from lookup based on current day and pass on the to the sendmail command.
| inputlookup test.csv where [| makeresults
| fields - _time
| eval Days=strftime(now(),"%a")
| table Days]
| table email
| map search="index=_internal sourcetype=scheduler savedsearch_id= status= skipped | stats count by reason| sendemail to=\"$email$\""
Refer to answer from @woodcock for using map command for sending email with context : https://answers.splunk.com/answers/399434/send-emailed-results-to-an-email-address-in-the-re.html#answer-399515
... View more