I am new to VBA. Can yu help me with a macro to automatically send email 30 days before the due date.



Column A3:A100 I will have vendor name

Column B3:B100 I will have Description

Column F3:F100 I will have expired dates

Column G3:G100 I will have emaill address


Subject will be 'The below contract expires in 30 days from now.


The macro should pick up all the details from the 4 column of the row of which the expiry day is before 30 days from today.

Thanks for your help in advance.



Kind Regards,

Sunil