Email alert if date exceed due date and status cell = open

I don't know if a way to generate emails using formulas or functions.
You may want to ask an administrator or moderator to move this thread to the VBA forum.

Thread moved to the VBA section.

What do mean by "email Header"?

Apologies for late reply.

Sorry, by header I actually meant Email Subject.

How do you want to trigger the alert email to be created? Do you want to run a macro manually to check the dates? Do you want to do this automatically when you select an email in column U, open your file or activate the "Master" sheet? Please clarify.

Place this macro in the code module for ThisWorkbook. Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. In the left hand pane, double click on "ThisWorkbook". Copy/paste the macro into the empty window that opens up. Close the window to return to your sheet. Save the workbook as a macro-enabled file. The macro will run each time the workbook is opened. The appropriate emails will be created and displayed for you to review. Then you will have to manually send each one. If you want the emails to be sent automatically without reviewing, change "Display" in the code (in red) to "Send" (no quotes).

Please Login or Register  to view this content.

Many thanks for this. However, its not working for me. Nothing happens when I open the workbook. If I manually run the macro, Outlook does open and does put the two email addresses in correctly. However nothing else is filled in.

Edit:- I changed the date of Rem 3 Date to todays date and ran the macro again and it does now put "Reminder 3,12345, part, Task Due" in the subject.
Its not running upon opening the sheet though.

Edit2. Please forgive my stupidity. I didnt paste this to my workbook. Now updated and working. Many thanks.

You are very welcome.