find first available appointment by examining several calendars

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.

Thanks.
LVL 4
GordonPrinceAsked:
Who is Participating?
 
GordonPrinceConnect With a Mentor Author Commented:
I got this to work using Outlook's Recipient.FreeBusy, in case anyone else looks for a way to do this.
0
 
GordonPrinceAuthor Commented:
I'm using Outlook 2007, Access 2007 and Exchange Server 2007.
0
 
GordonPrinceAuthor Commented:
I got this to work using Outlook's Recipient.FreeBusy, in case anyone else looks for a way to do this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.