Send E-mail Alert For Overdue Deadlines

  • I send a lot of documents out from my office (mostly invoices) to people in other departments for certification. It is difficult to keep track if and when these docs have been returned. What I want to do is send out an automatic email alert to the person responsible (the person the doc was sent to), once a certain period of time has elapsed (like say 15 days). I use microsoft outlook for sending emails.

    I have attached an excel sheet with some sample rows with comments for reference.