[jspidy]

i have come up with this query for my confirmation email
how do i trigger it when the submit button is pressed on the form

<cfquery name="mail_call_collect" datasource="register">
SELECT FirstName, LastName, UserName, Email, Password, PhoneNumber
FROM reguser</cfquery>
<!-- confiramtion email code start -->
<cfmail query="mail_call_collect"
from="jasonspidy@hotmail.com"
to="#mail_call_collect.Email#"
subject="Your Registration Detials">

Dear #mail_call_collect.FirstName#

Thank you for registering with us Your Username Email and Passwotd details are below,

Please keep these details safe for future reference..

#mail_call_collect.Email#
#mail_call_collect.Username#
#mail_call_collect.Password#


You can edit your account when you want just by logging on and click the edit account link
</cfmail>

i dont seem to have any errors this is on a seperate page to the form but i have linked it through the record set on the registration form will this trigger it??
and would using hotmail smtp in the coldfusion mail settings cause a problem

cheers jspidy