发送邮件的方式是:
Private Sub Application_Reminder(ByVal Item As Object)
Dim oMail As New MailItem
oMail.Subject = "[Reminder]:" & Item.Subject
oMail.To = Application.Session.CurrentUser
oMail.Send
Set oMail = Nothing
End Sub
在收到邮件后,在rules and alerts中创建一个规则,对于收到邮件进行检查,如果收到以[Reminder]:开头的,去执行一个脚本即可