PC Review


Reply
Thread Tools Rate Thread

On completion of a task, can I email a copy of the task to myself

 
 
=?Utf-8?B?UmljaGFyZCBU?=
Guest
Posts: n/a
 
      14th Jun 2007
When I mark a task as completed, I would like a VBA macro to automatically
send an email to me with the details of the task. Is there existing code
that can do this, or can someone help me figure out how?

I would like to customize the subject of the email with the start and end
dates of the completed task.

Thanks,
Richard
 
Reply With Quote
 
 
 
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      15th Jun 2007


The ItemChange event of the task folder tells you when an item changes, see
the sample in the VBA help file.

In that event you can check the item's Status property. If it's
olTaskCompleted then create an email with the Createitem function, add your
address via Recipients.Add and write in the subject and body property
whatever you want, e.g. the values of the TaskItem's StartDate and EndDate
properties.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize Outlook email:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 14 Jun 2007 08:12:01 -0700 schrieb Richard T:

> When I mark a task as completed, I would like a VBA macro to automatically
> send an email to me with the details of the task. Is there existing code
> that can do this, or can someone help me figure out how?
>
> I would like to customize the subject of the email with the start and end
> dates of the completed task.
>
> Thanks,
> Richard

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Task completion does not follow up to the originator of the task. Eric Barnett Microsoft Outlook Discussion 1 3rd Mar 2008 02:25 PM
Completion of assigned task does not remove it from my task list =?Utf-8?B?TGludXM=?= Microsoft Outlook Discussion 0 9th Nov 2007 07:27 PM
Copy an email into a task/Create a task from an email =?Utf-8?B?TWFyYXZpbGxh?= Microsoft Outlook Discussion 5 4th Oct 2005 11:14 PM
Task completion status of an assigned task PBOS Microsoft Outlook 0 29th Sep 2004 03:52 PM
Task completion Brandi Microsoft Outlook 2 23rd Dec 2003 06:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:13 PM.