How to let excel send an e-mail based on specific date on Excel cell

[mmtantawi]

Dear all,

My name is Mohamed, i am working in Polic Department, we are issue a Drive License for our people.

I made an Excel sheet file called ( DR.xls). this excel sheet have only one sheet with it called ( DR-INFO ).

This sheet, have 8 colums as following :-
1-#
2-Drive Number
3-Day of Issue - Di
4-Month of Issue-Mi
5-Year of Issue-Yi
6-Day of Expire -De
7-Month of Expire- Me
8-Year of Expire-Ye

and i am writing all the data on this excel sheet.

I want to do something, because the number of Drive Lilcesnce is about 700 .

What i want to do, is, i want to write a code to do the following :-

on every day @ 10:00 AM , the excel sheet will open the file which is called DR.xls, and will look to only three colums which they are day off expire, month of expire, year of expire. and then to compare the date of today, and in case of the date of what is looking to is equal to what is in the excel sheet, he will send an e-mail to notify the follwoing with the drive license number , and date of expire , to the following :-

xyz@sam.com.

i am using MS-Outlook 2007.

can anyone please help me by this.

regards,
MT