VBA code to automatically send email whn a date is reached in excel

[Bvendett4]

Good Afternoon,

I have one sheet that holds revision due dates in columns 'D', 'I' and 'N' , when the revision due dates are reached in this column, I would like an email reminder sent out on this date and also 14 days later if the date has not been changed, this will be to multiple email addresses (around 5) and through Outlook.

Is this possible?

Many Thanks

 

[Logit]

Please explain why you have revision dates in three different columns.

Might be best if you could post a sample of your workbook to a cloud site (i.e., DropBox.com, Amazon cloud, etc.) to make it easier to work with.

 

[Bvendett4]

Re: VBA code to automatically send email when a date is reached in excel

Of Course,
My apologies, there are three worksheets in my work book - these are generated into a fourth work sheet which holds three columns to show when the revision date of the tasks are due based off their date modified date, which is read through a VBA code.

https://www.dropbox.com/s/hsw4oha81p8s16t/Risk Assessment Register.xlsm?dl=0


So - basically - a new risk assessment is created and saved, a VBA runs when saved and generates this new file into a hyperlink in to the risk assessment column, this is also then copied into the fourth sheet - the saved file is saved with its overall rating of high, medium or low, a formula then calculates based on this the revision date off the date created, whether it needs re-assessing in 1 year, 2 years or 3 years. When the file is modified i.e. re-assessed the VBA code picks this up and the new revision date is generated. I would appreciate a VBA code that sends reminders based on all 3 columns as there are 3 separate worksheets that collect information into the fourth.

Also just a quick question - if this was possible - would the email generated be able to have specific text generated into the email on creation?

Many Thanks
I look forward to any assistance that can be provided.

 

[Logit]

.
Ok ... so what it comes down to is : Risk Assessment Register / Columns D, I, N.

When the dates in Cols D, I or N is a current date, you need an email to be sent notifying you.
What is the text in the email you are asking about ?

 

[Bvendett4]

Yes, thanks for the help

The text in the email would be something generice like
"Dear All,
This is assessment is due for review, please ensure this is complete within 14 days.

Many Thanks"