View Single Post
  #4  
Old July 29th 09, 08:56 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.


Ads