found this answer on a thread in the UK. might help someone
else.
only sends one email when form submit button is pressed.
added this code
if request.form("submit1") = "Send Form" then
'where submit1 is name of submit button and Send Form is
value of submit button
ObjSendMail.To = "jimb@jbwebworks.com"
ObjSendMail.Subject = "check entry form database"
ObjSendMail.From = "pco@pcogolf.org"
' we are sending a text email.. simply switch the comments
around to send an html email instead
ObjSendMail.HTMLBody = request.form("_email")
ObjSendMail.Send
Set ObjSendMail = Nothing
'also needed to add this
end if
%>