PDA

View Full Version : send mail automatically on a specific date



arnab0711
06-27-2012, 03:23 AM
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.

arnab0711
06-27-2012, 09:54 PM
Hi all,
Please advice,if its possible.

CodeNinja
06-28-2012, 07:18 AM
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 )