PC Review


Reply
Thread Tools Rate Thread

Automatically Purging Completed Tasks

 
 
Orion Cochrane
Guest
Posts: n/a
 
      6th Oct 2009
I would like to know if there is a way that a task can be deleted once
completed. I already have a filter that hides completed tasks, but they'll
build up over time. Ideally, I would like to click the Complete field to mark
it completed, and have the task automatically deleted. If I can get a prompt
before deleting, that would be excellent.

This is probably more of a VBA question, but I thought I would try here
first, as I am only familiar with Excel VBA programming.

TIA
--
I am running on Office 2003, unless otherwise stated.
 
Reply With Quote
 
 
 
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      6th Oct 2009


That's possible with VBA. You can adapt this example, which assigns a
category to a completed task:
http://www.vboffice.net/sample.html?...owitem&lang=en

After checking for the Status property, and instead of assigning the
category, just call Task.Delete.

--
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, 6 Oct 2009 09:30:01 -0700 schrieb Orion Cochrane:

> I would like to know if there is a way that a task can be deleted once
> completed. I already have a filter that hides completed tasks, but they'll
> build up over time. Ideally, I would like to click the Complete field to

mark
> it completed, and have the task automatically deleted. If I can get a

prompt
> before deleting, that would be excellent.
>
> This is probably more of a VBA question, but I thought I would try here
> first, as I am only familiar with Excel VBA programming.
>
> TIA

 
Reply With Quote
 
Orion Cochrane
Guest
Posts: n/a
 
      6th Oct 2009
That worked great! Thanks.
--
I am running on Office 2003, unless otherwise stated.


"Michael Bauer [MVP - Outlook]" wrote:

>
>
> That's possible with VBA. You can adapt this example, which assigns a
> category to a completed task:
> http://www.vboffice.net/sample.html?...owitem&lang=en
>
> After checking for the Status property, and instead of assigning the
> category, just call Task.Delete.
>
> --
> 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, 6 Oct 2009 09:30:01 -0700 schrieb Orion Cochrane:
>
> > I would like to know if there is a way that a task can be deleted once
> > completed. I already have a filter that hides completed tasks, but they'll
> > build up over time. Ideally, I would like to click the Complete field to

> mark
> > it completed, and have the task automatically deleted. If I can get a

> prompt
> > before deleting, that would be excellent.
> >
> > This is probably more of a VBA question, but I thought I would try here
> > first, as I am only familiar with Excel VBA programming.
> >
> > TIA

>

 
Reply With Quote
 
Orion Cochrane
Guest
Posts: n/a
 
      6th Oct 2009
Is there a way to permanently purge these completed tasks as opposed to
moving them to the Deleted Items folder? Something like a Shift+Delete
operation.

Thanks.
--
I am running on Office 2003, unless otherwise stated.


"Michael Bauer [MVP - Outlook]" wrote:

>
>
> That's possible with VBA. You can adapt this example, which assigns a
> category to a completed task:
> http://www.vboffice.net/sample.html?...owitem&lang=en
>
> After checking for the Status property, and instead of assigning the
> category, just call Task.Delete.
>
> --
> 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, 6 Oct 2009 09:30:01 -0700 schrieb Orion Cochrane:
>
> > I would like to know if there is a way that a task can be deleted once
> > completed. I already have a filter that hides completed tasks, but they'll
> > build up over time. Ideally, I would like to click the Complete field to

> mark
> > it completed, and have the task automatically deleted. If I can get a

> prompt
> > before deleting, that would be excellent.
> >
> > This is probably more of a VBA question, but I thought I would try here
> > first, as I am only familiar with Excel VBA programming.
> >
> > TIA

>

 
Reply With Quote
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      7th Oct 2009


If you use the Redemption (www.dimastr.com), that's easier. With Outlook you
have to monitor the ItemAdd event of the Deleted Items folder, and there
delete incoming items once again.

--
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, 6 Oct 2009 12:44:01 -0700 schrieb Orion Cochrane:

> Is there a way to permanently purge these completed tasks as opposed to
> moving them to the Deleted Items folder? Something like a Shift+Delete
> operation.
>
> Thanks.

 
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
automatically add time to the "date completed" column in tasks? jodydavis1983 Microsoft Outlook Discussion 1 22nd Aug 2009 11:16 PM
display completed tasks in the calendar day they were completed =?Utf-8?B?SkpSYW1DSFM=?= Microsoft Outlook Calendar 2 5th Aug 2006 01:44 AM
Automatically record completed tasks in Journal? Dexter Jettster Microsoft Outlook 1 5th Jul 2006 10:56 AM
How do I remove completed tasks from active tasks in Outlook2003 =?Utf-8?B?cnVzbWFy?= Microsoft Outlook Discussion 0 4th Mar 2005 12:23 PM
Automatically delete completed tasks sandy Microsoft Outlook 1 14th May 2004 07:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:23 PM.