CCK and email assistance

Hey Everyone,

I'm in need of some assistance to try and get something working. I have created a custom content type for activities which are assigned to individuals. This way everyone on a team can view work assigned to them, and to others. This is not the problem and is already setup.

However I need an email sent in two situations.

The first email I need sent to the person the activity is assigned to when the manager creates/assigns it.

The second email I need sent to the manager when the activity is set to completed.

The information for both needs to be referenced from two of the CCK fields. One is labaled assigned to, which contains the uid of the person recieving the email, and the second is labaled status which when changed to "closed" sends an email.

At first I though the actions module would be the best way to go, however I soon realised that the module is dependent on other modules, and NOT content types. This being the case I could only set something up to email a predefined email address with the creation of all nodes, and not just a specific node type.

I then though workflow might be the route to go, but realised that I would not be able to send an email to the person defined in the assiged to list. I also realised that in order to get this to work for the second email it would have to rely on its own values and not the values of the cck field.

I need this to work so it can be done using the values in the cck fields, and not seperate ones.

Any and all help is greatly appreciated.