Hello all,

I am creating some excel tools for project templates. On one of the tools, each sheet (each project) has a number of rows, one row for each action item. A column on each sheet list the due date for each action item, which I have already added conditional formatting to change the row either green, yellow or red the closer the real date gets to the actions due date. What I need to do is add a check box at the end of each row (for each action item) to select if email notification is to be made once the action gets say 5 days away from the due date. I then need another cell in each row to add email address that will be notified when the identified time to due is reached. I would just like a simple email that goes to each address and says something like, "Action item (insert text from action item) is about to go late".

I've been told by our overworked IT department this can be done using VBA so I have purchased a couple of books. I cannot find the time to correctly learn what I need to do. I was hoping the experts could give me some help here. This simple function would really be a huge help and I would greatly appreciate if anyone could help me out.

Thanks
Lance