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=subscribeforumid=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=subscribeforumid=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 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:


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=#eaeaeatd colspan=7 class=textblackbold
style=font-size: 12pt;E-mail /td/tr

trtd colspan=3nbsp;/td/tr

tr
td class=textblack colspan=3
cfoutputThere 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=commentscfoutput#FORM.comments#/cfoutput/textarea
/td
/tr

trtd colspan=3nbsp;/td/tr
tr
td colspan=3 align=centerinput 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=subscribeforumid=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 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


cfsilent
!--- how many messages are sent per operation? ---
cfset variables.RunRate=10
!--- How many seconds between attempts? ---
cfset variables.ReRunRate=16
cfset variables.PerMinute=60/variables.ReRunRate
cfset variables.HourRate=variables.RunRate*variables.PerMinute*60
cfparam name=url.RunType type=string default=NORMAL
cfquery 
name=RecShow 
datasource=#request.SiteDSN# 
cachedwithin=#CreateTimeSpan(0,0,1,0)#
SELECT 
cm_topics.ID,
cm_topics.PageText,
cm_topics.Title
FROM cm_topics
WHERE 
cm_topics.ID=#client.EditMarker#
/cfquery
cfquery 
datasource=#request.SiteDSN# 
name=GetSelf 
cachedwithin=#CreateTimeSpan(0,0,1,0)#
SELECT 
cm_users.Email
FROM cm_users
WHERE 
cm_users.ProCode=#client.Producer#
/cfquery
cfquery 
datasource=#request.SiteDSN# 
name=MailRun 
cachedwithin=#CreateTimeSpan(0,0,1,0)#
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
/cfquery
cfparam name=url.ThisStart default=1 type=numeric
/cfsilent
cfheader name=Expires value=Sun, 06 Nov 1994 08:49:37 GMT
cfheader name=Pragma value=no-cache
cfheader name=cache-control value=no-cache, no-store,
must-revalidate
cfif ThisStart GT MailRun.RecordCount
htmlheadtitleFINISHED/title/headbody
bgcolor=#FF ONLOAD=history.go(1)
H1font color=#008000All Done/font/H1
bfont color=#80You should close this browser
window/font!/b
pbDo not press your BACK button/b to leave, or you could
wind up sending some email messages all over again.
/body/html
cfelse
cfoutput query=MailRun
cfset form.MessageBody=RecShow.PageText
/cfoutput
cfset variables.NextStart=url.ThisStart+20
cfset variables.NextDisplay=url.ThisStart+19
cfif variables.NextDisplay GT MailRun.RecordCount
cfset variables.NextDisplay=MailRun.RecordCount
/cfif
!--- set a UUID in the url to help make sure the browser keeps
the page out of the cache. ---
cfset variables.UURL=UrlEncodedFormat(CreateUUID())
html
cfoutput
meta 
http-equiv=REFRESH 
content=#variables.ReRunRate#;

URL=#CGI.SCRIPT_NAME#?ThisStart=#variables.NextStart#UURL=#variables.UU
RL#
/cfoutput
headtitleLow Volume Mass Mailer/title/headbody
bgcolor=#FF ONLOAD=history.go(1)
font FACE=Georgia, Times New Roman, Times
!--- 
this is version 1, tested over time to work fine at large
volumes 
---
cfset variables.ContentValue=text/html; charset=  chr(34) 
iso-8859-1Chr(34)
cfmail 
to=#MailRun.EmailAddr#
from=#GetSelf.Email#
subject=#RecShow.Title# 
server=#Settings.EmailServer#
query=MailRun 
maxrows=#variables.RunRate#
startrow=#url.ThisStart#
type=HTML
#RecShow.PageText#
cfmailparam name=Reply-To value=#GetSelf.Email#
cfmailparam name=Message-ID
value=#CreateUUID()#@#Settings.EmailServer#
cfmailparam name=Content-Type
value=#variables.ContentValue#
cfmailparam name=Mime-Version value=1.0
/cfmail
cfset
variables.NumLeft=MailRun.RecordCount-(variables.NextDisplay-1)
cfset
variables.TimeLeft=fix(variables.NumLeft/variables.PerMinute)
cfoutput
H1font color=##80Sending messages/font
#url.ThisStart# font color=##80thru/font
#variables.NextDisplay#/H1
table border=1 cellpadding=4 cellspacing=0
bgcolor=##cc 
tr
td align=rightSPAN class=FormBodyTotal to

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=subscribeforumid=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

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=subscribeforumid=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 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=subscribeforumid=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 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=subscribeforumid=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 
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=subscribeforumid=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 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=subscribeforumid=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=subscribeforumid=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