find first available appointment by examining several calendars
Posted on 2011-09-15
From Access or Outlook VBA, I want to check 1-4 people's Calendars to find out who has a 60 minute availability next. I want to report back what that date is.
I was thinking I would loop through days, one a time,
for each date, check each user's calendar to see if there is any availability
Once I find one, exit the loop and report the user + date back in a msgbox.
Anyone have any experience about how to go about doing this? I.e., does Outlook expose objects that can do this, what are they, etc.