[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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.
0
GordonPrince
Asked:
GordonPrince
  • 3
1 Solution
 
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
 
GordonPrinceAuthor Commented:
I got this to work using Outlook's Recipient.FreeBusy, in case anyone else looks for a way to do this.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now