Thanks for the help!
What would you suggest for the numbers of messages and the interval?
ryo
----- Original Message -----
From: "Steve Nelson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 02, 2000 8:46 AM
Subject: Re: Sending e-mail in a batch
> I do that all the time. It's a very powerful method of emailing users
> because it helps to spread the load out on both your mail server and
> your CF server. Here's the code I use. User_newsletter_logs has two
> fields: user_id, date_sent, first I load that table with the users I'm
> sending the message to, then I run this code every X minutes with the
> scheduler. select top 10 is a SQL 7 thing, not sure if it works in
> Access or not.
>
> <cfquery name="getxemails" datasource="#request.maindsn#">
> select top 10 u.user_id,u.first_name,u.last_name,u.email, u.password
> from users u,user_newsletter_logs unl
> where unl.date_sent is null
> and u.user_id=unl.user_id
> </cfquery>
>
>
> <cfloop query="getxemails">
> <cfmail to="#email#" from="[EMAIL PROTECTED]" subject="The Fusebox
> eBook is available!">
> Dear #first_name# #last_name#,
>
> blah blah blah
>
> </cfmail>
> <cfquery name="sentemails" datasource="#request.maindsn#">
> update user_newsletter_logs
> set date_sent=#now()#
> where user_id=#user_id#
> </cfquery>
> </cfloop>
>
> Steve Nelson
> http://www.SecretAgents.com
> Tools for Fusebox Developers
>
> ryo watanabe wrote:
> >
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_000D_01C044A2.2579BDA0
> > Content-Type: text/plain;
> > charset="Windows-1252"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi,
> > I was wondering what would be the best way to send e-mail in a batch. =
> > Say batch of 100 e-mail messages every hour. I am using a shared =
> > hosting and do not have access to the mail server. I need to query a =
> > database for the e-mail addresses that match a certain set of =
> > requirements, and send e-mail to those addresses. There would be no =
> > problem if there are less than 100 addresses, however, if there are 300,
=
> > I want to send those in 3 batches.
> >
> > The database is updated while sending e-mail, so query result must be =
> > somehow kept track of...
> > Any suggestions and/or ideas are welcomed.
> > Thanks in advance.
> >
> > ryo
> >
> > ------=_NextPart_000_000D_01C044A2.2579BDA0
> > Content-Type: text/html;
> > charset="Windows-1252"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META http-equiv=3DContent-Type content=3D"text/html; =
> > charset=3Dwindows-1252">
> > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT size=3D2>Hi,</FONT></DIV>
> > <DIV><FONT size=3D2>I was wondering what would be the best way to send =
> > e-mail in a=20
> > batch. Say batch of 100 e-mail messages every hour. I am =
> > using a=20
> > shared hosting and do not have access to the mail server. I need =
> > to=20
> > query a database for the e-mail addresses that match a certain set
=
> > of=20
> > requirements, and send e-mail to those addresses. There would be =
> > no=20
> > problem if there are less than 100 addresses, however, if there are 300,
=
> > I want=20
> > to send those in 3 batches.</FONT></DIV>
> > <DIV><FONT size=3D2></FONT> </DIV>
> > <DIV><FONT size=3D2>The database is updated while sending e-mail, so =
> > query result=20
> > must be somehow kept track of...</FONT></DIV>
> > <DIV><FONT size=3D2>Any suggestions and/or ideas are =
> > welcomed.</FONT></DIV>
> > <DIV><FONT size=3D2>Thanks in advance.</FONT></DIV>
> > <DIV><FONT size=3D2></FONT> </DIV>
> > <DIV><FONT size=3D2>ryo</FONT></DIV></BODY></HTML>
> >
> > ------=_NextPart_000_000D_01C044A2.2579BDA0--
> >
>
> --------------------------------------------------------------------------
----------------------
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
