Automated Email from an ASP.NET Web Page / SQL Database

I am not sure if what I want to accomplish is possible, or where exactly to begin....

I am building websites that will write information submitted by the viewer to a SQL Database. One of the pieces of information collected is the viewer's email address. I already have the website sending the viewer an email confirming the submission of their information after they click the Submit button. Now, I want to have an email sent on a regular basistoany viewerwho has clicked the submit button.

For example, Joe visits my site, enters his email address, and clicks submit. Then, Jane visits and clicks submit. Now, every Monday,email is sent to Joe and Jane to the email addresses that are stored in the SQL Database.

Can someone give me an idea where to start? Or tell me if what I'm envisioning is possible?

Thanks in advance!

 

Perhaps you can use DASP's Scheduled Task feature. It's in the Control Panel for your site.