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.