sending e mails from excel via outlook at diferent stages depending on cell data

[peter renton]

Hi
I have attached a trial wb.

I have a code that will send an email depending on a date in column f.
It sends it to the email in the code.

What i am trying to acheive is that when column f date is today it will send an email to the persons email responsible in the row or from a list.if the operator enters a yes in column g no more emails until the date in column h is reached to continue all year. But if the cell in column g remains blank another overdue email would be sent until yes is enterd.

Each row could have a different email

And there would be at least 7 sheets for diferent sites

Is this possible ???

Any help would be appreciated

Peter