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
Bookmarks