Solved

get list of calender appointment from resource mailbox calendar

Posted on 2014-03-19
3
339 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 19

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 19

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Find out what you should include to make the best professional email signature for your organization.
how to add IIS SMTP to handle application/Scanner relays into office 365.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

830 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