Send e-mail based on cell value

[Dietcoke1953]

I am trying to get spreadsheet to send an e-mail to a me based on a certain number of days before the date in a cell.

Example:

Spreadsheet that tracks calibration dates of tools, one cell has the date of calibration, the next cell is the next due date. Want excel to send me an e-mail 30 days before the date in the next due date cell.

Thanks for your consideration

[Logit]

.
.
Paste this in ThisWorkbook module :

Please Login or Register  to view this content.

Paste this in a Routine Module :

Please Login or Register  to view this content.

The above presumes you are checking a date located on Sheet 1, A1. That can be edited to suit.

[Logit]

.
.
To prepare an email for sending rather than just a notice ... change the macro code in the Routine Module to this and
delete the command button and comments on Sheet 1 :

Please Login or Register  to view this content.