2

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?

2 Answers 2

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.

3
  • Could you detail a bit about how to create a search view?
    – crush
    Jan 17, 2014 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. Jan 17, 2014 at 21:48
  • Thanks for the links. I'll give this a shot, and let you know if it works.
    – crush
    Jan 17, 2014 at 21:54
0

In Outlook search for "completed:19/09/2022..23/09/2022", but with the start and end dates you want to find tasks for.

What is a bit confusing is that when you type completed the suggestions are just "last week" , "today" and "last month" etc, but typing the dates in the above format does work.

example search result

1
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    Nov 1, 2022 at 9:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .