I'd like to have an outlook task created every time a cell states that a task is needed.

For Instance, an update is due on a certain date, and when it is 3 weeks before that date i want a task reminder in outlook to pop up.

it would look like this

A1 B1 C1
Client 1 Review date 1 review report due date 1
client 2 Review date 2 review report due date 2
Brian C 9/15/10 8/25/10

There could be as many as 50 clients in any given year. Each would have a due date. I'd like to have a task created automatically when the due date is entered and a alert given 3 weeks prior to the due date

I've seen some VBA that accomplishes something similar, but it is when one cell meets the criteria.