B
B
Bcoon2019-08-26 22:43:36
Macros
Bcoon, 2019-08-26 22:43:36

How to get a list of all repetitions of a task for a specified period?

For the specified period (Date From and To) you need to get a list of all tasks from Outlook. Moreover, for repeating, all individual instances must be specified. I can't figure out how to solve. For appointments, it is possible to use the GetOccurance method , which takes a date and checks if there is an appointment for it. For tasks, unfortunately, the method does not work.
So far, I could think of only the following: apply GetReccurancePattern to the task , read the recurrence parameters and calculate the dates on which recurrences fall. Then check with the right ones. But the options for setting repetitions are extremely diverse, and writing them all in the code looks like a task, at least, very laborious.
There is another option. When exporting tasks via File - Export for the specified period, all repetitions of the task are uploaded to CSV. Can eat a way to do such export through VBA? (although, of course, it is better in the code to iterate over individual instances of task repetitions).
In general, if anyone knows how to solve - share)

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question