Solved

find first available appointment by examining several calendars

Posted on 2011-09-15
3
400 Views
Last Modified: 2012-05-12
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
Comment
Question by:GordonPrince
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
3 Comments
 
LVL 4

Author Comment

by:GordonPrince
ID: 36546009
I'm using Outlook 2007, Access 2007 and Exchange Server 2007.
0
 
LVL 4

Accepted Solution

by:
GordonPrince earned 0 total points
ID: 36593008
I got this to work using Outlook's Recipient.FreeBusy, in case anyone else looks for a way to do this.
0
 
LVL 4

Author Closing Comment

by:GordonPrince
ID: 36593012
I got this to work using Outlook's Recipient.FreeBusy, in case anyone else looks for a way to do this.
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question