Set outlook to send email when due date is reached

Hi

Is it possible to set excel to send an email or alert when a due date is reached. I'm fairly new to using excel and am mostly self taught so have a limited understanding. Basically I have a spreadsheet that when certain dates are reached I need to action was hoping I could get it to set up some kind of pop up alert. I have already set some conditional formatting but could really do with a more notable alert.

Thanks In Advance for any help

Try here:

http://www.rondebruin.nl/win/section1.htm

Check the section: Mail Add-ins for Excel for Windows

Thanks for the reply xenixman

Having read the what's on the link you posted I have tried to adapt this to my needs however I fear this is beyond my capability.

I think I have made some progress on this.

I can now get it to send an email, however what I need is for an automatic email to be sent based on the dates in Col AL and Col AN these will be the due dates.

This is what I have so far:
Option Explicit

Sub Mail_small_Text_Outlook()

Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)

strbody = "Hi there" & vbNewLine & vbNewLine & _
"This is line 1" & vbNewLine & _
"This is line 2" & vbNewLine & _
"This is line 3" & vbNewLine & _
"This is line 4"

On Error Resume Next
With OutMail
.To = "[email protected]"
.CC = "another email address"
.BCC = "another email address"
.Subject = "STREETWORKS NOTICE"
.Body = "This is an automated message generated to notify of streetworks notice due"

.Send

End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing
End Sub

Any suggestions as to what I can add to make this work the way I need it to?

Many Thanks

Thanks for the links.

My VBA skills are pretty dismal too, have to admit most of what I've done has started life on the net.


Think I'll leave the slightly dodgy sounding link till I'm at home just in case my employers question my actions.