We're purchasing (and may have already purchased) iMS. But here's what I've
done in the past:
START WITH A FORM SOMETHING LIKE THIS:
<cfparam name="form.startrow" default="1">
<cfparam name="form.endrow" default="300">
<cfparam name="FORM.SUBJECT" default="some subject line">
<cfparam name="FORM.comments" default="">
<CFform action="hub.cfm?action=send_email&#CLIENT.URLtoken#" method="post"
name="frm_email">
<table border="0" WIDTH=400 cellspacing="0" cellpadding="0"
ALIGN="center" class="textblack">
<tr bgcolor="#eaeaea"><td colspan=7 class="textblackbold"
style="font-size: 12pt;">E-mail </td></tr>
<tr><td colspan=3> </td></tr>
<tr>
<td class="textblack" colspan=3>
<cfoutput>There are currently #FindRecords.recordCount# records in the
database</cfoutput>
<br>
<br>
Use the form below to generate an e-mail.
<br>
<br>
For best results, only 300 e-mails should be sent out at a time. Select the
start row and end row numbers.
<table width="100" cellpadding="4" align="left">
<tr>
<td class="textblackbold" nowrap>
<cfinput name="startrow" required="yes" message="The
Start Row field is required" size="4" maxlength="4"
value="#form.startrow#"><br>
Start Row
</td>
<td class="textblackbold" nowrap>
<cfinput name="endrow" required="yes" message="The
End Row field is required" size="4" maxlength="4" value="#form.endrow#"><br>
End Row
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="textblackbold" nowrap width=50>
Subject: </td>
<td colspan="2" width=350>
<cfinput name="SUBJECT" required="yes" message="The
Subject field is required" size="56" maxlength="128"
value="#FORM.SUBJECT#"></td>
</tr>
<tr>
<td class="textblackbold" nowrap colspan=3>
Body: <br>
<textarea cols="48" rows="8"
name="comments"><cfoutput>#FORM.comments#</cfoutput></textarea>
</td>
</tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td colspan="3" align="center"><input type="submit"
value="SEND" class="textblackbold"></td>
</tr>
</table>
</cfform>
THE SUBMISSION WILL SEND TO THE FOLLOWING QRY PAGE AND FORM IS
REINCLUDED IN THE RESPONSE SO YOU CAN SEND OUT THE NEXT BATCH.
<cfset StartRow = #form.startrow#>
<cfset EndRow = #form.endrow#>
<CFSET NewBody = comments>
<cfmodule template="../tags/wrap.cfm" variable="NewBody" width="80">
<cfloop query="FindRecords"
startrow="#StartRow#"
endrow="#EndRow#">
<cfmail to="#FindRecords.EMAIL#"
from="[EMAIL PROTECTED]"
subject="#form.subject#">
#NewBody#
</cfmail>
</cfloop>
<cfset form.startrow=form.endrow+1>
<cfset form.endrow=form.endrow+300>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
