Email a reminder notice based on a date

[dakotajohn]

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.

[gsnidow]

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

Greg

[dakotajohn]

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

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

Greg