Assuming cat_email is the column returned from your query that includes the email addresses. Check the help for cfmail.
<cfmail to="#getEmails.Cat_Email#" from="[EMAIL PROTECTED]" subject="#subject#" server="abc.net" type="HTML"> <cfmodule template="clear_newsletter.cfm"> </cfmail> ----- Original Message ----- From: "Dowdell, Jason G" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 9:31 AM Subject: RE: ColdFusion based mass email module > Please explain what you mean by a "query for the to field". > Here's what I'm currently doing... > <cfoutput query="getEmails" group="cat_email"> > <cfmail to="#Cat_Email#" from="[EMAIL PROTECTED]" subject="#subject#" > server="abc.net" type="HTML"> > <cfmodule template="clear_newsletter.cfm"> > </cfmail> > </cfoutput> > Thanks, > Jason > > -----Original Message----- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 8:57 AM > To: CF-Talk > Subject: Re: ColdFusion based mass email module > > > Before you buy a program, you may want to try using cfmail's ability to > use a query for the to field. You will see better performance than with > a loop, it might just be enough. > > jon > > Dowdell, Jason G wrote: > > Hi All, > > > > I have a customer who is running into page timeout errors while using the > > cfmail tag. The mailing list query contains about 5,000 records in it so > > we're looping through the cfmail tag that many times. I know I can set > the > > requesttimeout attribute in the url but I'm looking for a more robust > > solution > > that's preferably ColdFusion based. I seem to remember someone wrote > > a custom tag based in java that handled several thousand email addresses > > without a problem. Can anyone point me to some custom tags or modules > > that have been fairly reliable at least up to 10,000 emails? > > > > Thanks, > > Jason > > > > <!--- > > Jason Dowdell > > [EMAIL PROTECTED] > > 321.799.6845 > > IM AES - Web Developer > > ---> > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
