I'm building a site in ASP with an Access DB. Part of the database holds member info. Is it possible to have the database automatically send out renewal emails on the anniversary someone joined. At the minute I would have to manually run a report and manually send the email.

I figure there must be a way of an email being sent automatically without any intervention by me but I haven't a clue how to do it.

I a bit of a novice at programming too.

I've also posted this question in the SQL section as I didn't know whether it was a SQL or ASP question.

getting the database to do the work can be tricky

I would use an asp page that runs the report and sends an email (using CDO or similar). Then you just have to goto this page and all the neesecary emails are sent. You could even hide the function on your home page so anytime anyone comes to your site the function is run. This will give you some sort of psuedo - automation anyway.