Search code examples
excelvbaoutlookexchange-server

How to iterate through Microsoft Exchange shared calendars in VBA?

Where I could find a code snippet which allows me to iterate through Appointments in a Exchange based system? The point is to check all the appointments in a given range of time and extrapolate some data to an Excel worksheet.

Solution

  • It is not clear when and where you need to run such code/task. The possible options are:

    1. Automate Outlook to get all the required information from the user profile (mail profile). See How to automate Outlook from another program for more information.
    2. Use EWS (Exchange Web Services). See EWS Managed API, EWS, and web services in Exchange to get started quickly.