Scheduling Emails
When scheduling Emailing one should consider using Windows Scheduler to fire a Task which could then touch a SharperLight URL address that has logic to send emails. The Caching Tab of Publisher has buttons that build the command line syntax that can be pasted into Windows Scheduler. Alternatively you could launch a command line to execute a Query that has been saved as a File and contains logic to send emails
The Query Builder Expression that sends emails can vary the To email addresses by basing the list on Query Filters, Outputs, Sub Queries of the Report itself.
E.g. You may have a Hidden Prompt Only Sub Query Filter that builds up the email list based on certain criteria and the Expression uses this List as it’s email list.
In this example the Sub Query would have a Expression that would turn 10 rows of email address into a ; separated result by using a Expression to concatenate them together then use another Expression to suppress all rows but the last RowSkipAllButLast()
To periodically refresh a Web Page as a primitive polling mechanism that conditionally sends emails if some condition is meet would work.
However if the page is closed then the polling would stop. For this reason I would recommend Windows Scheduler
Emails in General
Query Builder – Emailing Reports
Command Line Options