Thanks a lot the macro is working fine.

But I tried scheduling this in windows but the mail is not getting triggered .

Kindly help please sorry for the inconvinence .