I have a scheduled task that sends out 30,000+ each day. I have a field in the database "Sent" I SELECT the TOP 1000 WHERE Sent = 0
Then loop through them and update each to Sent = 1 Then when the RecordCount LS 1000 I update the whole table setting the Sent back to 0. Rick -----Original Message----- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 11:47 PM To: CF-Talk Subject: Re: Email Quandry I know you mentioned that this is a freebie on your part. If this is a temporary thing then you can get a 60-day demo of iMS-SE from our web site. iMS-SE is a high-performance mail sending engine for ColdFusion that allows you to send volumes of mail without requiring an external email server. It's also about 1/4 of the price of other CFMAIL replacements and is the only one that does not require the external mail server. You can see a feature comparison of iMS-SE versus other products at the link in my sig, below. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Michael Greenberg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 12:05 AM Subject: Email Quandry > Hi folks, > I have an issue with an HTML email newsletter I am trying to send out. I > have a database of approximately 11,000 email addresses I need to send this > newsletter to. Is there a way that I can send this out to about 100 > addresses at a time? I need some sort of mechanism to loop through the > database grab 100 email addresses and send. I'm using CF 5 on Windows 2K. > > Thanks, > Michael > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
