Trying to send auto. emails based on different criteria

I am needing to send automatic emails based on due dates when they become past due. Each row has it's own due date and it's own person & email address assigned to it. I am looking to have each row send an email when each due date is past due to each specific person assigned to that task. I have attached a copy of the spreadsheet I am currently working on. I am extremely new to Macros, but have the basics down of how they work. This is the current one I am using:

Please Login or Register  to view this content.

Here are the rules I am looking for:
1. When any row in Column "B" has a past due date, I want an email to send to the corresponding person in Column E on THE SAME ROW. Example: If B5 is past due, I want an email to send ONLY to the person in E5. If B10 is past due, I want an email to send ONLY to the person in E10.
2. When the email is created, I want the body to pull A1 as well as the information from column C in the corresponding row. Example: If B5 is past due, I want the email to send to the email address listed in E10 with the body of the email containing A1 and C10.

I may not even be using the correct Macro above. Any recommendations will be gratefully appreciated!

I apologize. I am new to this! Thank you for the fix and I will guarantee any future ones will have the correct criteria!

That worked! Thank you SO MUCH! Question for you, I am creating multiple tabs copied off the same sheet that have all of the same applied rules. Will that Module overlook the entire workbook? Or will I need to run the Sub individually on every worksheet?

For this process to work on a different tab, copy the code in the sheet module into the new tabs sheet module