Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

get list of calender appointment from resource mailbox calendar

Posted on 2014-03-19
3
Medium Priority
?
346 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 2000 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

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

New style of hardware planning for Microsoft Exchange server.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

704 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