Solved

get list of calender appointment from resource mailbox calendar

Posted on 2014-03-19
3
343 Views
Last Modified: 2014-04-13
I want to get list of calender appointment from resource mailbox calendar.
It would be good if i can get in excel format.

I have full access to resource calender from outlook.
I am using outlook 2010
We use Exchange 2010.

Is there a way to do it from outlook? or is there a power shell i can run export report/list?
0
Comment
Question by:itadminhelp
[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
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
Peter Hutchison earned 500 total points
ID: 39939347
Add the resource mailbox to our outlook profile:
a) right click 'Mailbox - your name'
b) select Data File properties
c) Click Advanced button, then Advanced tab
d) Add the resource mailbox
e) Click OK a few times

To view the calendar by Event:
a) Select the resource calendar
b) Click on the View tab, select Change View and select Events
c) Appointments are now shown as a list

To export the calendar:
a) Select File, Options
b) Select Advanced
c) Click on Export button
e) Select 'Export to a file'
f) Select 'Microsoft Excel 97-2003'
g) Select the resource calendar from the list
h) Enter filename
i) Click Finish
j) Enter date range to export. Click OK to start export
0
 

Author Comment

by:itadminhelp
ID: 39941348
Hi cmsxpjh,

I have added resource mailbox in my outlook.

When i export file i can't see resource calender in the list. (but i can see it in calender section)

Do you know why that would be ?
0
 
LVL 20

Expert Comment

by:Peter Hutchison
ID: 39941842
Try setting up a new outlook profile for your resource mailbox and load up into that so that the resource calendar will be available to export.
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

622 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