the easiest way is to create script, let the script read the data and send it for you.
If you have SQL server, the script should be part of SQL scheduler.
Cauze you post it here, I expect that you have MDB file..... so create VBS script and use schduler to run it every day....
Also sending email is different for Outlook, Lotus Notes or pure Win2k Server Eail API. I uses here Win2k Server API. If you have Outlook, let me know and I can change it.
there are two ways....
first you go through list of recipients and send to each a letter, the other (and I like it more) is to send one letter to everybody. In this case you have to create query, where all users are sticked into one field and text of the email to the other.
note: you don't need to have MS Access installed on the server.
myRecSet.Open "SELECT * FROM qryList ", myConnection, adOpenStatic, adLockReadOnly
Do While Not myRecSet.EOF
'here you stick sending piece....
'it is different for Outlook, Lotus Notes or basic Win2k Server Email API
Set objCDOMail = CreateObject("CDONTS.NewMail")
objCDOMail.From = "myE-mailHere@myDomain.com"
objCDOMail.To = myRecSet.Fields("UsersEmailsGroupofEmails")
objCDOMail.Subject = "Here is your newsletter"
'Set the e-mail body format (0=HTML 1=Text)
objCDOMail.BodyFormat = 0
'Set the mail format (0=MIME 1=Text)
objCDOMail.MailFormat = 0
objCDOMail.Body = myRecSet.Fields("BodyOfTheEmailinHTMLFormat")
Set objCDOMail = Nothing