RE: Email Quandry

2003-01-09 Thread Matt Robertson 
The code below will work fine for you.  It will throttle down your mail
send rate.  As is it'll send your 11000 emails in 45 mins or so.

This abomination was created when my ISP didn't want me sending more
than about 600 msgs per hr on his shared server.  I still use it to keep
those overzealous spam filters that Jochem mentioned from catching on
(AOL and Hotmail, particularly).  It's very low-tech, but it works.

My ReRun rate is tied to my server's cfmail spool pickup interval (15
secs), and yours should be too.  Note I added an extra second in there
to make sure the spool is flushed.

A solution for grown-ups would be iMS, but I can't figure out a way
around AOL's temporary blocking schemes that will let me shoot out mail
in qty.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com
  -  -  -  -  -  -  -  -  -  -  -  -  -  -  
 Site Design and ColdFusion Developer Tools











SELECT 
cm_topics.ID,
cm_topics.PageText,
cm_topics.Title
FROM cm_topics
WHERE 
cm_topics.ID=#client.EditMarker#


SELECT 
cm_users.Email
FROM cm_users
WHERE 
cm_users.ProCode=#client.Producer#


SELECT 
cm_email.EmailAddr
FROM cm_email
WHERE 
cm_email.EmailAddr IS not NULL
AND
cm_email.ParentID=#client.EditMarker#
ORDER BY
cm_email.ID ASC







FINISHED
All Done
You should close this browser
window!
Do not press your BACK button to leave, or you could
wind up sending some email messages all over again.
















Low Volume Mass Mailer




#RecShow.PageText#








Sending messages
#url.ThisStart# thru
#variables.NextDisplay#
 

Total to
send:
#MailRun.RecordCount#


Total
Remaining:
#variables.NumLeft#


Estimated
Completion:


About #variables.TimeLeft#
minutes

Less than one minute.




This page will send email in batches of #variables.RunRate#
messages at #variables.ReRunRate#-second intervals, for an hourly
throughput rate of #variables.HourRate# messages per hour.

You should leave your computer completely untouched and wait
for this job to complete.  When it finishes, you will be notified.




~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Email Quandry

2003-01-09 Thread Owens, Howard 
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:










E-mail 

 



There are currently #FindRecords.recordCount# records in the
database



Use the form below to generate an e-mail.



For best results, only 300 e-mails should be sent out at a time. Select the
start row and end row numbers.





Start Row




End Row










Subject: 







Body: 
#FORM.comments#



 







THE SUBMISSION WILL SEND TO THE FOLLOWING QRY PAGE AND FORM IS
REINCLUDED IN THE RESPONSE SO YOU CAN SEND OUT THE NEXT BATCH.













  

   


#NewBody#



 








~|
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

RE: Email Quandry

2003-01-09 Thread cfhelp 
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

Re: Email Quandry

2003-01-09 Thread Jochem van Dieten 
Michael Greenberg wrote:
> Im just concerned with 11,000 emails going out at once that it might bring
> the server down. Yes it is via SMTP.

If the emails are identical you could send them to yourself and BCC them 
to a bunch of people at the same time (I think the limit is 39). Usual 
overzealous spam filter warnings apply, especially since you want to 
send HTML email.
Sending them all as single mails with cfmail shouldn't be a problem 
either, but I would recommend setting the spool interval to 15 seconds 
(after which they should be out of the spool in half an hour).
If you have some mailserver on the system that has a pickup folder, you 
could also write the emails as files to that pickup folder.

Jochem

~|
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

Re: Email Quandry

2003-01-08 Thread paul smith 
Anyone here not familiar with iMS should take a look as it is virtually 
infinitely configurable using ColdFusion (as well as others).

best,  paul

At 12:47 AM 1/9/03 -0500, you wrote:
>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,

~|
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

Re: Email Quandry

2003-01-08 Thread Howie Hamlin 
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
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

Re: Email Quandry

2003-01-08 Thread Michael Greenberg 
Im just concerned with 11,000 emails going out at once that it might bring
the server down. Yes it is via SMTP.

Thanks,
Michael

- Original Message -
From: "Paris Lundis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 12:13 AM
Subject: Re: Email Quandry


> should be no big problem with a set that small... what is happening
> wrong? and what mail server are you sending this stuff to?  type of
> SMTP server...
>
> Paris Lundis
> Founder
> Areaindex, L.L.C.
> http://www.areaindex.com
> http://www.pubcrawler.com
> 412-292-3135
> [finding the future in the past, passing the future in the present]
> [connecting people, places and things]
>
>
> -Original Message-
> From: "Michael Greenberg" <[EMAIL PROTECTED]>
> Date: Thu, 9 Jan 2003 00:05:02 -0500
> 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Email Quandry

2003-01-08 Thread Paris Lundis 
should be no big problem with a set that small... what is happening 
wrong? and what mail server are you sending this stuff to?  type of 
SMTP server...

Paris Lundis
Founder
Areaindex, L.L.C.
http://www.areaindex.com
http://www.pubcrawler.com
412-292-3135
[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: "Michael Greenberg" <[EMAIL PROTECTED]>
Date: Thu, 9 Jan 2003 00:05:02 -0500
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
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Email Quandry

2003-01-08 Thread Michael Greenberg 
Peter,
The only issue I have with that is that this is a quick hack that I am not
getting paid to do.I will look at this in the future though when I rebuild
this tool and I have a budget to work with.

Also cfdev is down :)

Thanks,
Michael

- Original Message -
From: "Tilbrook, Peter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 12:06 AM
Subject: RE: Email Quandry


> Check out ActivMail (http://www.cfdev.com)
>
> ==
> Peter Tilbrook
> Internet Applications Developer
> Australian Building Codes Board
> GPO Box 9839
> CANBERRA ACT 2601
> AUSTRALIA
>
>   WWW: http://www.abcb.gov.au/
>E-Mail: [EMAIL PROTECTED]
> Telephone: (02) 6213 6731
>Mobile: 0439 401 823
> Facsimile: (02) 6213 7287
>
>
> -Original Message-
> From: Michael Greenberg [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 9 January 2003 4:05 PM
> To: CF-Talk
> 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
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Email Quandry

2003-01-08 Thread Tilbrook, Peter 
Check out ActivMail (http://www.cfdev.com)

==
Peter Tilbrook
Internet Applications Developer
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2601
AUSTRALIA

  WWW: http://www.abcb.gov.au/
   E-Mail: [EMAIL PROTECTED]
Telephone: (02) 6213 6731
   Mobile: 0439 401 823
Facsimile: (02) 6213 7287 


-Original Message-
From: Michael Greenberg [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, 9 January 2003 4:05 PM
To: CF-Talk
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Email Quandry

2003-01-08 Thread Michael Greenberg 
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4