Check out example 2 here
http://www.rondebruin.nl/mail/folder3/message.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Samuel Looney" wrote in message ...
I have a workbook that I created that has a column containing dates. These
dates are due dates. I would like to write a procedure to execute on workbook
open that will check these dates. I have written the code that will iterate
through each row in the column in each worksheet. Now I am trying to figure
out how to write this sub to do the following but I am not sure of the syntax.

If dueDate <= 30 days from now Then
send email
End If

I am just not familiar with working with dates in Excel. Does anyone have
any suggestions?
Thanks
End If