Problem with generating multiple email with message body, subject and emails automatically

I am very new to programming. I have been working on this for months, but i still couldnt solve it.
My task here is to generate email automatically.
When i enter x to run the sub findvalue macro.
Any cells on the column D that has the value of 10 should generate email with the message body, subject and email address automatically.
example if there are 3 task that are 10 days to deadline, 3 email will be generated after entering "x"
I have edited the Sendmail sub to locate the email's body, subject line and email from the excel.
that is the ideal case, however, i have a problem executing the macro. I don't really understand the whole code so i need find in this.
Please look at the attached workbook.
Any help is appreciated

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks for your help! finally i get some result.