Reminder emails after 30 and 60 days.

[meatcat]

Hello everyone,

First time post here! Just found the forum a few days ago. I am very impressed at the gratitude of everyone in helping others solve problems. Here's mine:

I would like to make a macro that sends seperate emails to managers at 30 and 60 days after a new hire's start date. (See attached worksheet for more detail)

The problem is that I have no idea how to write VBA. If anyone would be kind enough to look at my worksheet and give me some direction, I will wish good karma upon you and your family forever.

Thanks for your help!



30 60 Evaluations.xlsx

[Leith Ross]

Hello meatcat,

Welcome to the Forum!

The macro below will check the worksheet hire dates. If today's date is either 30 or 60 days past the hire date and there is no email date for the 30 or 60 day mark, a email will be sent using Outlook. The attached workbook contains the macro shown and a button on the worksheet has been added to run the macro.

Macro Code

Please Login or Register  to view this content.

[meatcat]

Hello Leith,

Thank you so much for your work on this.

I have noticed that the emails are instantly sending when I click the button without regard to start date. After I click the button, is there a way for the macro to send the email 30 days after the start date and then another one after 60 days? I would like the emails to send on the date populated.

Is there an easy way to remove the warning that requires the user to click allow?

I am sorry for the hassle, Leith! Thanks again.