?
Solved

Query Microsoft Exchange Calendars

Posted on 2014-11-05
1
Medium Priority
?
132 Views
Last Modified: 2014-11-10
Hi Experts, just checking whether there is a way of querying the contents of users calendars and populating a public folder or Excel spreadsheet or text file or using ASP.NET/VB.NET. In our case we want to query all the appointments/meetings for the sales team and put them in one place for the management to see their movements without manual intervention. Is this possible?
0
Comment
Question by:takwirirar
[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
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40423762
Yes - to get your relevant calendar folder, use this code:

    Set nms = Application.GetNamespace("MAPI")
    Set fld = nms.Folders("NAME").Folders("Calendar") 

Open in new window


And then loop through the items in that folder:

for each itm in fld.Items
   debug.print itm.Start, itm.End, itm.Subject
loop

Open in new window


There will be some error-checking you will need to add, and exporting it into the spreadsheet or text file etc., but those are the basics.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
In this video we show how to create a Shared Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Sha…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
Suggested Courses

766 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