Hi -
I am working on a Gantt chart template to be used by a workgroup, each member completing different tasks, each reliant on the previous task's completion. What I am looking to do is have an auto generated email sent to the person completing the next task when the previous task is completed. Also, the sheet will be saved, edited and resaved on a Sharepoint site.
For example, in the attached sheet, I would like an email to be generated when a date is entered in column H, Actual Complete Date, to let the person responsible for the next tast know that they can begin their task.
For now, those needing email notification is within one specific work group, but the template would have application in other areas, so understanding how to adjust who receives the emails would be valuable to me.
From my previous searches it looks like this will involve some work in VB, in which I have limited knowledge. But, I'm a quick learner and would appreciate any help/advice anyone would be able to give.
Thanks in advance,
Walt
Bookmarks