automatic e-mail

I'm trying to create a stored procedure that will send an e-mail automatically. My app is a html form / cgi/vbscript /Access97 DBase app. The parameters I'm using are stored in a Membership table, and the e-mail is based on unique MemberID. Since this is a stored procedure, I don't want to base it on a button event.

I can't find an example of this anywhere on the web or in any of my VB books.

Any help is appreciated.

thanks,

cdt

check out cdonts in vb help. IIS SMTP Server
Must be installed for this to work. I'm not sure
how it would work in an access stored proc, but I have
done it from SQL7

[Edited by BG on 04-26-2000 at 01:45 PM]