Email Notification When Database is Updated

[Guest]

Hi, I'm using ASP javascript and an Access database to capture members.  How do I send an email to myself when my database has been updated with a new member?

[bregent]

You simply need to add an email script that executes after the database update script.

[Guest]

Thanks -- a couple of followup questions:

-- when do I do that, ie. where in the code? 

-- any details about the email script would be appreciated

Thanks

[Guest]

--after the update code as mentioned. You never provided code so no one can tell you specifically where because in our eyes your code is non-existant.

--use the email script you found by searching google for ASP email script. Oh wait... you mean you didn't search before you asked?!? bwhaaaaat?

shame

[Guest]

The script I plan to use is this (customized with my own email info of course.)

<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="someone@somedomain.com"
myMail.TextBody="This is a message."
myMail.Send
set myMail=nothing
%>

But I don't get how to implement it, or if I'm missing anything I need.  I'm sure it's very simple for most, but I'm struggling. I really don't know what comes next.  I appreciate any direction.