Hi phocused

You can add a formula that display yes in a column if it is one day before the problem next update date
Date column = for example B

=IF(TODAY()=B1-1,"yes","no")
and copy down

Then if you run this macro every day it will create the mails for you
http://www.rondebruin.nl/mail/folder3/message.htm

post back if you have problems


--

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


"phocused" wrote in message ...
Hi, hopefully someone can help me, i have searched the forums but not sound
anything that fits.

I have a spread sheet which has a problem ref, prob description, prob owner,
prob next update date fields

I review the problems each morning with the owners and update the
spreadsheet then send it out.

what i would like to do is on the day before the problem next update date,
send the owner a mail notifying him that he needs to attend the meeting the
following morning and he will need to provide and update.

Is this possible?

Rgds Paul