send email when task changes

  • Thread starter Thread starter Kevin Edwards
  • Start date Start date
K

Kevin Edwards

Hi All

I've setup categories in my task list and shared it with my boss so he can
edit them

But I want some kind of audit trail. Otherwise I can imagine that on Monday
a task is at priority 4. On Tuesday he changes it to priority 1 - I don't
notice or he forgets and EOB Tuesday he's asking why it isn't done.

So if I could get some vba that would email me when a task is edited with a
certain subject line, I could create a rule to file them and have my audit
trail. Thanks.
 
This example demonstrates how a changed property triggers the ItemChange
event. In the event you can check for the Priority property, and use the
CreateItem function to create an email:

http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=52&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 27 Jul 2009 20:06:01 -0700 schrieb Kevin Edwards:
 
Thanks tremendously Michael - my googling wasn't turning up much.

My VBAs very rusty. So before I get into this - rather than training my
boss to leave a note on his edits - will I be able to email what has changed
e.g. completion date or changes to the body.
 
No, you won't. For that you'd have to add a few steps: Use the Selection
change event of the ActiveExplorer, and whenever a new item gets selected,
temporarily store the properties of your interested in variables. When the
ItemChange fires, compare your stored data with the current property values
of the changed item.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Tue, 28 Jul 2009 13:35:01 -0700 schrieb Kevin Edwards:
 
Back
Top