how can i get an email sent to me when a date in an excel spreads.

[Guest]

I have a spreadsheet that tracks contracts. How can I get an email sent to me
when a date for a paricular contract expiration is coming up?

 

[Frank Kabel]

Hi
as a starting point:
http://www.rondebruin.nl/mail/change.htm

 

[Ron de Bruin]

Hi George

You can use the workbook open event
Example for 14 days

Private Sub Workbook_Open()
If Sheets("Sheet1").Range("A1").Value > Date - 14 Then
MsgBox "macroname"
End If
End Sub

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm

 

[Guest]

Ok, I think I will have to find someone that knows VB or macros in Excel,
cuz I don't know where to start. I did manage to get an email sent when a
change was made in a cell as per the program on your site, but not sure how
to specify dates in a cell, do some calcuations and logic and then send an
email.

Thanks all