email notification when auto registration is due

I have a list of company vehicles with the registration renewal dates in an adjacent column. I would like to have the vehicle VIN and due date emailed to a select group of people when the vehicle is 31 days from expiration. (The VIN is also listed in the same row as the renewal date) I would like to to occur, if possible, with the workbook closed.

Is there code for such an action?

Thank in advance - Charlie

Hi, have some viewpoint about your question .

1> when the vehicle is 31 days from expiration. send once or every time open excel file until expired ?
2> what kind of email client software you used , outlook or other , send mail method can be complex if not use outlook ole vba code
3> you minder email have special format or only simple text to note a mail list ?

1. Every time the file is open until the date is updated.
2. Everyone has outlook.
3. Simple text just to notify so action can be taken.

I recommend the following

use vba marco

1> for the expiration date column using VBA loop through each cell .

2> when judging the value of a cell line with expiration conditions, execution submitted by mail operation, concrete can be submitted to the entire batch or every cell submit the same batch or based on other columns were submitted to different recipients

3> perform to submit mail operation, following a period of operation code, e-mail can be automatically saved in the Drafts within OUTLOOK, please refer to.

Set olapp = CreateObject("outlook.application")
Set newmail = olapp.CreateItem(olMailItem)

With newmail
.To = "[email protected]" ' example email addr here
.Importance = olImportanceHigh
.subject = " subject content write here "

.Body = " what you want to write here

.save ' save in draft
'.Send

End With

' Set newmail = nothing
' Set olapp =nothing

Based on the sensitivity of the data, as well as to enhance the benefits of your skills
You can try to complete the self-service can continue to exchange problem, there are the difficulties encountered, gradually close to their ultimate desired goal