Send Automatic email IF certain cells are not completed by a certain date

[13102261]

Hi,
I am hoping someone can help me, i have very limited skills with Excel so will appreciate a point in the right direction
My manager has asked me to create a weekly report template which will send out an automatic reminder email if the report is not completed by Friday evening.

There are several point of contacts that will have access to this documents and will be responsible for entering the data for their regions.
I am using excel 2010 and would like the emails to be sent out via outlook. The point of contacts emails are located in the work sheet.
If you require any more information please let me know.

[13102261]

In case someone is super keen to help out , I have attached the basic template that i want to use.

The conditions i want to input are:
if todays date > ='due date + 1' and 'Countblank for columns B to J is > 0' then an email will be sent through to name1.surname@gmail.com saying " Dear Name1, This is a reminder to complete the weekly report for the week ending on 'B3' for 'City1'. Regards, Me"

This will need to be done for multiple rows.

Some of the point of contacts will also be looking after multiple cities so if theres a way in which they will only recieve the one email instead of multiple that would be good.



Simple Trial Weekly reporting template 2.xlsx