Looking for Submit Email Script

[jpeterson2517]

Does anyone have a script for simply a user submitting their email address for a newsletter?

I simply just want them to submit their email and it will go to the SQL database, and I will have it to send out our newsletter.

Thanks

Jeremy

[Dan_Bracuk]

cfform for them to submit it
cfquery for you to store it.

[murpg]

Try this.
<cfmail to="youremail@youremail.com" from="#form.email#" subject="Registration" type="html">
<table>
<tr>
<th>Variable Name</th>
<th>Value</th>
</tr>
<!--- loop over the Form structure and output all
of the variable names and their associated
values --->
<cfloop collection="#Form#" item="VarName">
<cfoutput>
<tr>
<td>#VarName#</td>
<td>#Form[VarName]#</td>
</tr>
</cfoutput>
</cfloop>
</table>
<cfquery>
INSERT INTO mytable
(email)
values
('#form.email#')
</cfquery>