I am trying to send an email to specified users when a column in a list changes in MOSS 2007 with workflow. I have a comments column in a list and whenever any user updates that comment, a mail should go to the creator and specific group stating what has changed.
I saw a response which states to create 2 lists and keep them in sync and compare values of comments from the two lists. But that is not a perfect solution.
Please help. Thanks in advance.