MS Access records into daily emails

[heavenly_blue]

My MS Access DB is updated every day with new records. I need my website to automatically email the new records to the people on my mailing list daily. How would I go about doing this? I also want the email to be formatted in such a way that the records look nice, my first choice would be to have a .rtf attachment containing all the new information. Any tutorials, special programs, code, suggestions are appreciated. Currently I'm using Dreamweaver UltraDev 4 and MS Access.

[Bullschmidt]

ASP News Letter by Faisal Khan
http://www.stardeveloper.com/asp_newsletter_1.asp
Loops thru recordset and sends an e-mail to each.

http://www.asp101.com/samples has some good e-mail examples such as the e-mail attachment example which uses the newer CDO (instead of the deprecated CDONTS which no longer ships with Windows).

[Anubis]

I don't believe you can have your site "automatically" send the report/newsletter. At least not with you're current setup. You can make an admin page (like in the above post) and then launch the emailer which can loop through your table of email address and send out the email to all of them. If you had a sql database a store procedure could be made that would send the email and you could schedule the job to run daily, giving you the "automatic" emails.