Email a reminder notice based on a date

This is my first post and I've looked everywhere, but cannot seem to find the correct formula/macro for my problem. I've created a spreadsheet to track our audits. Our goal is to update the spreadsheet at least weekly, if not sooner. I have my audit name, lead auditor, follow up auditor (may be different person in some cases), internal follow up date and (currently) an email notification reminder date. I've added a column, based on some posts I've seen, to indicate when the notification email was sent out... Can anyone help me out with this? I would like it to send emails once the spreadsheet is opened.

Please Login or Register  to view this content.

Thank you, Greg!! So, everything else about the formula looks correct?

Originally Posted by gsnidow

Put your email routine in a Workbook_open() event. It will fire when to workbook is opened.

Greg