send email when task changes
 

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.

send email when task changes
 

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?...cmd=showite m

--
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:

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.

send email when task changes
 

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.

"Michael Bauer [MVP - Outlook]" wrote:



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?...cmd=showite m

--
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:

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.

send email when task changes
 

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:

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.

"Michael Bauer [MVP - Outlook]" wrote:



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?...cmd=showite m

--
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:

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.