Send email when Status changes on form
I have been researching this for a while now and can not find a clear answer on how to do the following.
I have a project form and there is a Project Owner (prjOwner) and Project Manager (prjManager). They each can click a box that says "Send Email on Status Change". What I woudl like to do is if the Status changes on the project for it to send an email to the PrjOwner or PrjManager if they have selected they would like to have the email. It would be nice to include in the body of the email what it was and what it was changed to with a doclink if possible.
I have seen other answers with the OnChange event and with advanced LotusScript but I am at a loss on how to actually do this. Any suggestions?
I have a project form and there is a Project Owner (prjOwner) and Project Manager (prjManager). They each can click a box that says "Send Email on Status Change". What I woudl like to do is if the Status changes on the project for it to send an email to the PrjOwner or PrjManager if they have selected they would like to have the email. It would be nice to include in the body of the email what it was and what it was changed to with a doclink if possible.
I have seen other answers with the OnChange event and with advanced LotusScript but I am at a loss on how to actually do this. Any suggestions?
ASKER
I have the document for the steps already written (workflow diagram). I am stuck on how to set the value of the status field when the document is open, then how to compare what the value of the status was on close and if it is changed then send the email to the prjOwner.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When the document is saved, check the status field, if it's changed (compare the value using a profile document) send an email to the people in the "subscribers" field above.
You might do well to list out the steps that need to be performed from start to end to complete this task, maybe a flow diagram, then research each step in turn. Including attaching a docLink etc.