I saw here in this forum a thread about using sendmail to notify when there had been an addition, modification or deletion of a record within the database. However, I cannot seem to locate that thread anymore - could you please direct me? I have the script and almost eveything I need completed - there is just one more thing that was within the thread I cannot find.

thanks !

I found the thread finally ! Whew! I have the sendmail working for add/modify/delete now.... I have one problem - I want to know who made the addition/modification/deletion

I thought I could do this with the "userid" - so far I have been unsucessful in getting it to work.

This is what I have for add_success:

open (MAIL, "|$mail_prog -t");
print MAIL "To: support\@cocoahighalumni.com\n";
print MAIL "Reply-to: support\@cocoahighalumni.com\n";
print MAIL "From:$in{'userid'}\n";
print MAIL "Subject: New Record Added !\n";
print MAIL "\n\n";
print MAIL "The following user: ('$userid') has added a new record. \n" ;
print MAIL "\n\n";close (MAIL);

This doesn't seem to display the userid in the email for me? What do I need to do to get the userid to print in the email?

Thanks!

I also figured this out too - the userid should be UserID (case sensitive).

Don