auto email date coming due

Welcome to the forum

When do you want the email reminders sent out? When a button is clicked?

You only want it sent if its =30 days not <= 30 days(this may get excessive, it would equal 30 emails to one individual leading up to their review date)? Will it always be sent to the same email or differ depending on employee?

Okay. Can you upload a workbook with the identical format/headers etc but with dummy data to protect private information?

Is this for the physicians tab? the APP's tab? Both?

Okay. I think I understand. Review dates for Physicians and Hire Dates for Apps?

Okay, last question-

Do you want one email for all of the dates < 30 or one email for each person whos date is < 30?

This code is designed to run every time the workbook is open. Please note I had to use a helper column (AG) that will show you if the email has been sent (Yes) or has not been sent (blank). If you delete yes from the column you will get duplicated reminders. You might want to title this column email sent or reminder sent, something of the like.

The email address goes where in the red lettering.

Place this in your workbook module:

Please Login or Register  to view this content.