Need help in running the code automatically on a daily basis

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hi Freinds, I have this problem hoping one of you expert can resolve
the issue. Here is my code to send the email.
Private Sub SendEmailToAssignedTo_Click()
On Error GoTo Err_SendEmailToAssignedTo_Click
DoCmd.SendObject , "", "", Me![PRA_CTAC_NME], "", "", Me![SYS_NME],
"Please Respond with some more Data in order to proceed in
scheduling.", False, ""
Exit_SendEmailToAssignedTo_Click:
Exit Sub
Err_SendEmailToAssignedTo_Click:
MsgBox Err.Description
Resume Exit_SendEmailToAssignedTo_Click
End Sub

Here is my question:
SendEmailToAssignedTo is a command button on a from called frmPRA. On
the same form i have a control called RIT_AT_SCORE.
I want to send this email message on a daily basis until i have some
value in Me.RIT_AT_SCORE

That means i want this code to run once a day until i have some value
in Me.RIT_AT_SCORE.

Can someone help me out with this please.

Thanks
Moe
 
Back
Top