Scheduling email to be sent based on cell value- Please help!

I've posted a couple times before and haven't gotten much response. I desperately need to figure out how to have Excel send an email when the "status" of a task changes to "past due", and then at regular intervals after that until it is marked "complete" or "complete late".

I don't have enough programming knowledge to do this, but it seems as though there would be one conditional command to send the email when the status changes, and maybe a different one base on the # of days past due (every 7 days for example)

The email needs to go to the associated email address for the employee(s) selected on that line of the spreadsheet, with the administrator cc'ed on each one. We're using Lotus.

PLEASE let me know if you have any ideas. Spreadsheet is attached. Thanks!

This looks similar to what I'm trying to do, but I'm not sure what to change for my situation... http://www.excelforum.com/excel-prog...ell-value.html