I'm not sure if this is what you had in mind, but look at area #3 on this web
page:
http://www.microsoft.com/atwork/getw...treamline.mspx
tells how to set up Outlook tasks while you are in Excel.
Another way would be to set up some code in the Excel workbook, probably in
the Workbook_Open() or Worksheet_Activate() event that would look through the
list of dates on a particular sheet and toss up a message to you when a date
was 'today'. You'd have to open the workbook each day to get the alerts.
"craign27" wrote:
I am putting together a maintenance schedule worksheet on excel. As part of
this i wish to input future dates at which maintenance is required to be
performed. The excel document will be a live document. Is it possible that,
on the dates in question, i am alerted of the required maintenance with a
message or alarm, potentially through oulook or any other programme. i.e. is
there away that the date in the excel data box can be linked to an alert
function?