Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I use the task list quite extensively in Outlook 2010 to keep track of tasks I'm working on, and mark them completed when they are complete. This works well for me.

I'd like the ability to print a report or list of all the tasks, regardless of which folder they are in, that I've completed and are currently in progress, potentially in a given date range.

Is this type of functionality possible in Outlook 2010? If it's not possible natively, is there an extension that could accomplish this?

share|improve this question

1 Answer 1

You should create a search view for this.

Limit the search to the Task item type.

You don't need an add-in.

Here are some links for further reading:

Basically, it is like creating a new folder but you define a search instead of a simple folder. Outlook keeps the search updated for you.

UPDATE & CORRECTIONS

Having looked again, I realise that it is actually pretty hard to do a search in tasks. It did find some references to doing it via VBA (here and here) but that isn't too nice.

If you have Microsoft Access available though, it is pretty easy. You can link an Access table to the Outlook tasks folder and then do your reporting in Access.

If your tasks are stored in Microsoft Exchange and you are allowed to make connections to it, then Microsoft PowerQuery has a query connector that should allow you to do reporting in Excel (I've not tried this because our organisations Exchange is tightly locked down). PowerQuery is a free Business Intelligence addin for Excel.

share|improve this answer
    
Could you detail a bit about how to create a search view? –  crush Jan 17 at 21:21
    
I've not currently got access to my machine with Outlook 2010 but I've updated the answer with some links for further reading. –  Julian Knight Jan 17 at 21:48
    
Thanks for the links. I'll give this a shot, and let you know if it works. –  crush Jan 17 at 21:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.