email notification by excel with some specified conditions

Hello all!!
I need a help in excel macros. PFA for the reference. (test file)
Actually my mailing list are in the cells I2:P2 and the cc will be of Q2. The mail should be sent if only the status cell (F) will be pending/Partially completed. if the status is Completed then i need not to be send the mail. (This is the first condition) Then I need to check the target date (D) column if that is less than or equals to today, then the mail should be generated. for instance infact my status is pending and the target date which is not less than or equals to today means I should not send the mail ( This is the another condition). By inserting a button and assingning the macros to it


KINDLY HELP ME WITH THIS PROBLEM. Thanks in advance.test file.xlsxtest.jpg

KINDLY HELP ME WITH THIS PROBLEM

What problem? There's no mention of a problem in the post, it's a specification for work to be done.

I guess you mean the problem is the code does not exist yet?

Actually i dont have any code in the sheet i attached. my problem is the code I ont know hoe to do it thats y i need the help

The simplest of searches will get you one of the best pages to describe sending email with VBA: http://www.rondebruin.nl/win/s1/outlook/mail.htm

I tried all these but end up with so many errors !!

yes exactly that is only sample file I tried I ended up with errors that why i came here i am a beginner to excel so i need ur help. I didnt say effectively as "do my work"

Hope this will be work. thanks for your help