Notify of Predecessor's Impending Finish

This macro uses Outlook to notify team members when tasks to which they are assigned are about to start based upon the status of that task's predecessor.

A limitation of this macro is that it only notifies your resource if the tasks they are assigned to have predecessors. 

This macro will loop through all tasks in the currently active project.  It will check each one to see if the Percent Complete is => the value specified in IngPercentTHold.  If it is AND the value of Text30 is <> "Sent" then it will assign information to each resource assigned to the successor (if the task has a successor).

REQUIREMENTS--You will want to make sure that:

• The task Text30 field cannot be used for ANYTHING else.  If it is then you must change the Text30 references in the macro to some other unused taxt field.
• Set the IngPercentTHold variable to equal the % complete point you wish to have this email sent.
• Outlook Must be installed.  Right now there is not a reference to the Outlook Object Library.  You must set one first.  It was left unset because you may have Outlook 2000 or another rev. and the mpp file would very likely not open because of the broken reference.  VBA is funny that way.  You will need to open the mpp and then open the VBA editor and double click on the Module called ResourceNotify.  Then click on the Tools>References menu and from the list select the Outlook 8 or Outlook 9 object.  8 is Outlook 98 and 9 is Outlook 2000.  Then the macro will work.
• Make sure that your resources all have valid email addresses in the email address field in the Resource Sheet view.

Big Fat Disclaimer

We do not make any promises about the functionality of this macro. We do  not promise that it will work in all cases. The world is an imperfect place. The functionality of this macro provides a convenience to users but should not be relied upon for the timely completion of a project.

 Notify.txt
This text file contains the code for the macro. Check it out and customize it as you see fit. Learn from it and make it better if you like. If you make a big improvement let us know so we can let everyone benefit from your talents!