I have a user who would like to know the total percentage of time any
specific conference room is booked. We run Outlook on an Exchange Server and
our conference rooms are scheduled through Outlook meeting requests or
appointments as resources. Is there a way to pull this information?

Quick and dirty method:

1. Use a table view to display all the data fields that you want to export to Excel.
2. Choose Edit | Select All.
3. Choose Edit | Copy.
4. Paste to Excel.

Use Excel to calculate the difference between start and end date/times and add up the total.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"AnnC" wrote in message ...
I have a user who would like to know the total percentage of time any
specific conference room is booked. We run Outlook on an Exchange Server and
our conference rooms are scheduled through Outlook meeting requests or
appointments as resources. Is there a way to pull this information?

Sorry.... my question was not very clear. I need to be able to do this
programmatically. I am writing a windows app using vb .net. One of my
customer's 'like to have' requirements is to be able to see the percentage
use for their conference rooms from within the application.

"Sue Mosher [MVP-Outlook]" wrote:

Quick and dirty method:

1. Use a table view to display all the data fields that you want to export to Excel.
2. Choose Edit | Select All.
3. Choose Edit | Copy.
4. Paste to Excel.

Use Excel to calculate the difference between start and end date/times and add up the total.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"AnnC" wrote in message ...
I have a user who would like to know the total percentage of time any
specific conference room is booked. We run Outlook on an Exchange Server and
our conference rooms are scheduled through Outlook meeting requests or
appointments as resources. Is there a way to pull this information?

Then you'll need to iterate the items in the folder, read the value of the Duration property for each one, and total the results. Use the Namespace.GetSharedDefaultFolder to return each resource mailbox's Calendar folder.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/comm....program_v ba

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"AnnC" wrote in message ...
Sorry.... my question was not very clear. I need to be able to do this
programmatically. I am writing a windows app using vb .net. One of my
customer's 'like to have' requirements is to be able to see the percentage
use for their conference rooms from within the application.

"Sue Mosher [MVP-Outlook]" wrote:

Quick and dirty method:

1. Use a table view to display all the data fields that you want to export to Excel.
2. Choose Edit | Select All.
3. Choose Edit | Copy.
4. Paste to Excel.

Use Excel to calculate the difference between start and end date/times and add up the total.


"AnnC" wrote in message ...
I have a user who would like to know the total percentage of time any
specific conference room is booked. We run Outlook on an Exchange Server and
our conference rooms are scheduled through Outlook meeting requests or
appointments as resources. Is there a way to pull this information?