automatic emails please help me???

i have never done this before how do i generate
an email to a client based on a date in the datebase

how do i do this??
i have an sql database with a users table
and in it i want to check the entire users database
evryday
by clicking on say a Autoemail button from my admin. asp form
i want it to check the whole usersdatabase
field
Startdate and send those particular users including myself an automatic email giving them there login password and username to my website. but this has to be individual emails
because the username password are different for each user

my users table is as follows
UserID
Username
Surname
Email address
Startdate

i dunno where to start with this has anyone got any coding for me to play with to get this process going im using vb script??

or any ideas as what needs to be done
can it be done??

Firstly I suggest you figure out how to generate your randam password for each user. And then store it to the database.

After doing that, you could use the while.....wend function to go through the recordset and create the email recipent, subject, body that contains the username and password, and then sends the email.

emm.. if you need the code tell me, i can get it done for you. and another thing i am confused at. I think it is better you send the details automaticly upon registration. Wouldn't that be great.

Hi,
I'm able to generate emails by a click of a button. However I want to generate emails automatically without user's trigger, that is I want to emails to be sent, say..6pm daily without the clicking of the "Send" button.
Can anyone tell me how to achieve this?

Thank you very much.

hi

maybe you could write a function in global.asa to check what time is it when a user browse thru your website and execute the send email function when it's 6pm.

Hi,
My application is a stand-alone application..not a website...Is there any example that teach me how to write such a function?

Thank you very much.

hi there if someone tells you how to do that autoemail
on certain times of the day can you let me know the details

regards
john