Issue pulling future dated appointments from Outlook using Excel VBA

Hi,

I've found the following code online which I am attempting to use to pull a list of all appointments into Excel from Outlook. The issue I can't seem to solve is that it's only pulling historical appointments - and nothing that is scheduled to take place afterwards. This is the opposite of what I need - it's not a problem to have the past appointments in, but it is an issue not to have the future ones.

Any help appreciated!

Please Login or Register  to view this content.

EDIT: On further inspection, it does show future dated appointments - however the issue is that it's counting recurring appointments as one instance, and only showing the start/end time of the first occurrence. I need to show each occurrence as a separate instance for my purposes.