View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andee39 Andee39 is offline
external usenet poster
 
Posts: 4
Default Can Excel trigger Outlook reminder?

A little more info on the spreadsheet I want to create. We receive
corrrespondence from another unit that has a due date. This correspondence
is referred to an attorney in my unit. When the due date comes, I would like
to have an Outlook reminder sent to myself and the individual it was assigned
to. My column headers would be:
ID#
Name of constituent
Address (if applicable)
Date referred
Assigned to
Due date

Thanks.

"Andee39" wrote:

I hope I'm asking this question in the right forum. I would like to know if
it is possible to create a basic spreadsheet where one of the columns is for
due date and when that due date comes up a reminder is generated from
Outlook? I think I understood correctly from a Google search that it can be
done in Visual Basic but I have no idea how to do it. I'm also hoping it
would not be complicated b/c I have not used VB. If that can't be done, how
could I work it that the cell would change to red with due date comes?
Thanks.