one example would be a lookup table that holds information like days, week numbers, and the related email address that should receive the alert. Use that lookup in your search and you should be able to get what you want.
Hope this makes sense ...
I have a search with
"index=internal sourcetype=scheduler savedsearchid= * status= skipped | stats count by reason"
And in my lookup file:
Please can you help me with the search where I can send daily by rotation process
| 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#an...