Solved

Query Microsoft Exchange Calendars

Posted on 2014-11-05
1
122 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
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
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…
To show how to generate a certificate request 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 Servers >> Certificates…

733 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