Thread: Auto-generated emails from Excel

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

Mr. Rondebruin is the leading resource on this issue. His code examples can be read at the following address:
http://www.rondebruin.nl/sendmail.htm

Sending emails is a complex and advanced form of vba. You may need some coding assistance, particularly, as it relates to integrating his code examples with your particular application.