Automatically send Mail for Due Dates from Excel

I have a workbook which consisits of the due dates for which my employee has to be paid up.

Is it possible to generate a code which automatically sends an email from excel every day along with the employee name,employee ID and due date along with

the amount to be paid, which should go through the following:


Employee Id is in C2, C3, C4 and so on.... ( It is added periodically )

Employee Name is in D2, D3, D4 and so on....( It is added periodically )

Employee Salary is in J2, J3, J4, and so on....( It is added periodically )


Due Dates for 1st employee is feeded in k2,l2,m2,n2,o2,p2,q2 etc.....
2nd employee is feeded in k3,l3,m3,n3,o3,p3,q3 etc.....
3rd employee is feeded in k4,l4,m4,n4,o4,p4,q4 etc.....

and so on...


The report should be in two forms i.e., 7 days before due date


and

one month before due date.



Kindly help


Jane.

What email application are you using, Outlook, or Lotus Notes?