asked on

How can I send an automatic e-mail when a date field in a record is older than now?

I have records stored by a CF app, and in this app I have a "due date" field.

I want to send an e-mail to the person listed in the record as the owner, when the "due date" is older than now.

Any suggestions on how I can achieve this?

ASKER CERTIFIED SOLUTION

cheekycj

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TSellers

The method described above for the database query is great, it has inspired me to give it a try. As I have some code to actually send a decent looking email out I thought I would pass it along in case it can save you some time:

********************************************

<cfmail
 type = "html"
to = #Form.email#
from = "you"
subject ="the due date is older
than now."><body bgcolor="C0C0C0" text="000000" link="0000FF"></body><img src="http://www.yourdomain.com/images/backgrounds/yourlogo_logo2.gif" width="260" height="52"> 
#Form.fname#, the due date is older... 
<table width="75%" border="1" cellspacing="1" cellpadding="3">
<TR bgcolor="ffffcc">

<TD>SKU</TD>
<TD>ProductName</TD>
<TD>Brand</TD>
<TD>Unit Price</TD>
<TD>Qty</TD>
 <TD>Total</TD><TD></TD>
</tr>
 
<cfloop index="x" from="1" to="#SearchResult.recordCount#">
 <cfif SearchResult.ResultField5[x] is not 0>
 <tr><td>#SearchResult.ResultField1[x]#</td>
 <td>#SearchResult.ResultField2[x]#</td>
 <td>#SearchResult.ResultField3[x]#</td>
 <td>#DollarFormat(SearchResult.ResultField4[x])#</td>
 <td>#SearchResult.ResultField5[x]#</td>
 <td>#DollarFormat(SearchResult.ResultField5[x]*SearchResult.ResultField4[x])#</td><TD></TD>
 </TR> 
 </cfif>
</cfloop>
</TABLE>

<table width="45%" border="1" cellspacing="1" cellpadding="3">
<TR bgcolor="ffffcc">
<TD valign="top"> First name: </TD>
<TD>
 #Form.Fname#
 </TD>
 </TR>
 
<TR bgcolor="ffffcc">
<TD valign="top"> Last name: </TD>
<TD>

 #Form.Lname#

 </TD>
 </TR>


<TR><TR bgcolor="ccffcc">
<TD valign="top"> email address: </TD>
<TD>

 #Form.email#

 </TD>
 </TR>


<TR bgcolor="ccffcc">
<TD valign="top"> Ship-to Address: </TD>
<TD>

 #Form.Address1#

 </TD>
 </TR>


<TR bgcolor="ccffcc">
<TD valign="top"> Billing Address: </TD>
<TD>

 #Form.Address2#

 </TD>
 </TR>


<TR><TR bgcolor="ccff66">
<TD valign="top"> Phone: </TD>
<TD>

 #Form.Phone#
 </TD>
 </TR>


<TR bgcolor="ccff66">
<TD valign="top"> Fax: </TD>
<TD>

 #Form.Fax#

 </TD>
 </TR>


<TR><TR bgcolor="ccff00">
<TD valign="top"> Town: </TD>
<TD>

 #Form.Town#

 </TD>
 </TR>


<TR bgcolor="ccff00">
<TD valign="top"> Prov/State: </TD>
<TD>

 #Form.Prov#

 </TD>
 </TR>


<TR bgcolor="ccff00">
<TD valign="top"> Postal code/Zip: </TD>
<TD>

 #Form.Pcode#

 </TD>
 </TR>


<TR><TR bgcolor="99ffcc">
<TD valign="top"> Comments: </TD>
<TD>

 #Form.Comments#

 </TD>
 </TR>
 </table>

<table width="75%" border="0" cellspacing="0" cellpadding="3">

<tr>
<td class="tblwthbwite">
 
The attached
form is in Adobe Acrobat format,
if you do not have the Acrobat reader, Adobe Acrobat Reader
is free, and freely distributable, software that lets you view and print
Adobe Portable Document Format (PDF) files. In case you don't have it already,
here is the link address to download it: 
http://www.adobe.com/products/acrobat/readstep.html
Please
look at the invoice and confirm it is correct and acceptable. If so,
then please complete the Credit Card authorization form and fax it or
send it back via email. 
Please
feel free to contact us at any time if you require further assistance. 

 Warmest Regards, 

 Name 
 (403) 522-5252 
 HTTP://www.yourdomain.com/
 
</td>
</tr>
</table>
</body>
</html>


</cfmail>

cheekycj

Thanx for those very kind words :-)

CJ

dash420

better u can go for a sehduler of cold fusion.

webdiva69

uh create a scheduled job...

cheekycj

Guys, I stated that a job needs to be scheduled.. but the what job needed to be outlined too.