Wendy,

You could do create a job to run a stored procedure on a schedule to do this.

If you wanted to just send messages, you could do something like:

1. open a cursor of all the recipients,

2. generate the text file inside the loop.

3. email using sp_Send_DB_Mail stored procedure

4. (log).

and then loop...

If you're not sending an SSRS report, you don't need SSRS to be involved at all. Just create a job and a schedule to call the stored procedure you write.

You should check out this documentation on sp_send_dbmail