Friday, May 20, 2005

I Need An Auto Email Responder In Coldfusion

I am developing a email-based friends network management project with Coldfusion. I am sending periodic emails to the members according to particular time or date. So I need some kind of periodically executing code snippet.

Here you go:

<cfquery name="qryUsers" datasource="#DSN#">
FROM Users
WHERE datefield IS BETWEEN '2005-06-10' AND '2005-06-11'

<cfloop query="qryUsers">
<cfmail to="" bcc="" server="" from="" subject="Email Subject" type="HTML">
Hello #Fname# #Lname#,

How are you today?


Post a Comment

<< Home