VBA code to send mail automatically from outlook

Attached a sample workbook. Go through the code and update data in relevant cells.
PS: Use Windows schedulers to run the code at fixed timeline

Hi,

I tried running the it seems not working. Kindly help there is no error message coming.
But the mail also not getting triggered .
And also where do I find the windows scheduler.

Thanks in advance

Regards

Aravind

To execute VBA: attach your workbook with sample data.
Windows Task: Start->All Programs->Accessories->System Tools->Scheduled Tasks

Hi,

Thanks for the help.

Sorry for the inconvinence caused.

However what should I put in function/location/planned effort/actual effort/ status .

Do I need to fill all the cells. If left blank will the macro work.

Thanks in advance.

Regards,

Aravind

Hi,

Thanks for the help.

Sorry for the inconvinence caused.

However what should I put in function/location/planned effort/actual effort/ status .

Do I need to fill all the cells. If left blank will the macro work.

Thanks in advance.

Regards,

Aravind