A Lotus Notes approval reminder agent

The agent below reminds recipients of a Lotus Notes document that it is past due for their approval.

 REM "Send reminder of new 
requests to the Approver"; REM 
"Schedule is daily, not on weekends";

SELECT Form = "OSR2" 
& cDocStatus = "New";

REM "Initialize and increment Reminder counter"; 
jnReminders := @If(@IsAvailable(nReminders); 
nReminders + 1; 1) ; FIELD nReminders := 
jnReminders ;

REM "Write doc history";
jcDocHistory := "Reminder #" + @
Trim(@Text(jnReminders)) +
     " of Office Supply Requisition emailed to " +
      @Name([Abbreviate];cApprover) +
     " on " + @Text(@Now;"S2") ;
@SetField("cDocHistory"; 
cDocHistory : jcDocHistory) ;

REM "Add agent tracking fields." ;
FIELD dNotified := dNotified ;
@SetField("dNotified";
           @If(dNotified = ""; @Now; dNotified  : 
@Now)); FIELD cLastAgent := cLastAgent ; 
jcLastAgent := "Remind Approver" ; 
@SetField("cLastAgent"; 
@If(cLastAgent = ""; jcLastAgent;
   cLastAgent  : jcLastAgent));

REM "Email reminder";
jcSendTo :=@Name([Abbreviate]; cApprover); 
jcCC := "" ; REM "For testing, add a blind carbon copy" ;
 jcBCC := ""; jcSubject := "Reminder: Requisition for "  
+ cAssociate ; jcBody := 
"You have not responded to the Requisition for "  +
  cAssociate + ". 
Click the doclink at the bottom of this message!" ;

@MailSend(jcSendTo; jcCC; jcBCC; jcSubject; jcBody;
           ""; [IncludeDoclink])

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Stevenson Campbell. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.