Email to event

Hi,
sure, you can do this using View OnLoad event.

Here is the sample code:

function ViewOnLoad($where)

{
// Parameters:

// $where - string with WHERE clause pointing to record to be viewed

//** Send email with old data record ****

global $conn,$strTableName;

$subject="Put your subject here";
// modify the following SQL query to select fields you like to send

$rs = db_query("select * from " . $strTableName ." where ". $where,$conn);
if($data=db_fetch_array($rs))

{

mail($data["Email"], $subject, "your record has been seen");

}
}

where Email is your actual field name with email address.