|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
April 19th 06, 11:25 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
Can I get total time busy for a conference room in Outlook 2003?
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? 
|
| Ads |
|
#2
April 27th 06, 08:23 AM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Can I get total time busy for a conference room in Outlook 2003?
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?
|
|
#3
May 1st 06, 05:04 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Can I get total time busy for a conference room in Outlook 200
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?
|
|
#4
May 1st 06, 05:35 PM
posted to microsoft.public.outlook.calendaring
|
|||
|
|||
|
Can I get total time busy for a conference room in Outlook 200
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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook should show me where the conference room is | Don Garcia | Outlook - Calandaring | 0 | March 15th 06 06:06 PM |
| conference room calendars double booking | [email protected] | Outlook - Calandaring | 3 | February 28th 06 08:29 PM |
| How can I get Resource Mailboxes for conference rooms to auto accept appointments as 'busy' not tentative? | QH | Outlook - Calandaring | 2 | February 9th 06 04:49 PM |
| Meeting was booked in Conference Room, but is not on the calendar! | Renee | Outlook - Calandaring | 0 | January 25th 06 09:18 PM |
| Create Conference Room List in Outlook | jmolter | Outlook - Calandaring | 1 | January 20th 06 07:15 PM |
Linear Mode
