Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

find first available appointment by examining several calendars

Posted on 2011-09-15
3
Medium Priority
?
415 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
On September 18, Experts Exchange launched the first installment of the Help Bell, a new feature for Premium Members, Team Accounts, and Qualified Experts. The Help Bell will serve as an additional tool to help teams increase question visibility.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

618 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