Outlook VBA to report all incomplete tasks

I want to get Outlook Tasks/To Do data into an Excel report. However I am a noob when it comes to VBA in Outlook. I tried searching for existing code on the net but none of what I tried did what I want. The closest found created a report but it only reported a few of my tasks I had open (It used 'GetDefaultFolder(olFolderTasks)')

I am guessing that i need to loop through the MAPI? folders? in Outlook to pick up all of my tasks. Below is my attempt at mixing code from over the net to loop through my outlook folders and report any task that is incomplete. However I can't get the code to work. I run it on my Inbox folder and it doesn't detect any tasks. I probably have the looping code wrong but I can't work out where. Can anybody help?

Please Login or Register  to view this content.

Here's an example how to export Outlook Task Item to Excel by running the macro in Outlook. Make sure you have the MS Excel Library reference checked. If you only want to export task item with specific criteria, then, add your IF condition accordingly.

Here's the MS Documentation of all the task item property
'https://msdn.microsoft.com/en-us/library/office/dn352390.aspx

Please Login or Register  to view this content.

Thanks JieJenn - this is very similar to the nearest match I have found so far (as mentioned in the OP) The code doesn't pick up all my incomplete tasks as it uses GetDefaultFolder instead of looping through all folders to pick up tasks outside the standard Tasks folder.

When you say incomplete task, do you mean Status is not equals to "Completed"?

Originally Posted by JieJenn

When you say incomplete task, do you mean Status is not equals to "Completed"?

Correct. But that is not the problem, as per code in my OP, I can easily deal with those using

Please Login or Register  to view this content.

While your code works, it only lists tasks in the default Tasks folder and my tasks are across multiple folders. So I need code which will recursive search all outlook folders & subfolders. I tried writing this myself (see code in post 1) but it doesn't appear to be working.

Your code only processes the folders within the folder you selected, not that folder itself.

Originally Posted by rorya

Your code only processes the folders within the folder you selected, not that folder itself.

Yes, I know I have problems with the folder looping. I discovered another error, I am skipping subfolders where their parent folder doesn't contain items!

I am stepping through the folder loop function to see if I can solve it.

However I think I may also have problems with reading the tasks themselves (The subprocedure 'CheckFolderForTasks') UPDATE: For one thing, I have just discovered I need to edit the code to pick up mail items flagged as tasks.

I made several changes to the code and it looks as if it is starting to work. However there are several problems:

1. Speed. Looping through the folders is extremely slow. It would be quicker to read the 'To Do' 'view' in Outlook - if that is even possible. But how?
2. I'm not certain that the looping code is working 100% I would appreciate anyone pointing out if they can see any logic flaw in this code
3. Not a bug/just haven't coded - If it is not possible to read the To Do view then I need to also pick up the tasks in the Task folder and merge with the mail item tasks.

Please Login or Register  to view this content.

Persistence occasionally pays off. Below is quick and dirty code which solves this thread.

Please Login or Register  to view this content.