Usually I do everything in .net, so I'm not familiar with sending out emails from a stored proc. I'll have to research that. Do you have any examples...
I can write a stored procedure to get the emails from the database, but what about looping throught that list of emails and sending an email to each one separately?...