hi,
I have this contract tracker where rows turn red on expiry of contract.now is it posibble to send an auto mailer 30 days before the expiry date.
hi,
I have this contract tracker where rows turn red on expiry of contract.now is it posibble to send an auto mailer 30 days before the expiry date.
Hi all,
Please advice,if its possible.
A couple of options for you...
1 - put this in outlook and trigger a recurring macro to check for any matching items in excel
2- use application.ontime function to repeat a macro that searches for any dates that are today() - 30
(see a sample of application.ontime here: http://www.vbaexpress.com/forum/showthread.php?t=42604 )