Solved

get list of calender appointment from resource mailbox calendar

Posted on 2014-03-19
3
333 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
  • 2
3 Comments
 
LVL 18

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 18

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This video discusses moving either the default database or any database to a new volume.

757 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now