i run a series of meeting rooms; the diary being on outlook. what i'm wanting
to do is print off a report each month of what's been used, which room, by
who, and for how long (basically all the information inputted for each
item/event). how would I do this if I can as this would make billing much
much quicker as opposed to double clicking on each item in 4 calendars.

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.

If you want something more complex, consolidating your calendars, you'll need to write some code; see http://www.outlookcode.com/d/customexport.htm

--
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

"cmac66" wrote in message ...
i run a series of meeting rooms; the diary being on outlook. what i'm wanting
to do is print off a report each month of what's been used, which room, by
who, and for how long (basically all the information inputted for each
item/event). how would I do this if I can as this would make billing much
much quicker as opposed to double clicking on each item in 4 calendars.

how do i get a table view?

"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.

If you want something more complex, consolidating your calendars, you'll need to write some code; see http://www.outlookcode.com/d/customexport.htm

--
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

"cmac66" wrote in message ...
i run a series of meeting rooms; the diary being on outlook. what i'm wanting
to do is print off a report each month of what's been used, which room, by
who, and for how long (basically all the information inputted for each
item/event). how would I do this if I can as this would make billing much
much quicker as opposed to double clicking on each item in 4 calendars.

Use the commands on the View menu -- View | Arrange By | Customize Current View | Define Views to create a new view that you can reuse any time you want to perform this function.

--
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

"cmac66" wrote in message ...
how do i get a table view?

"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.

If you want something more complex, consolidating your calendars, you'll need to write some code; see http://www.outlookcode.com/d/customexport.htm


"cmac66" wrote in message ...
i run a series of meeting rooms; the diary being on outlook. what i'm wanting
to do is print off a report each month of what's been used, which room, by
who, and for how long (basically all the information inputted for each
item/event). how would I do this if I can as this would make billing much
much quicker as opposed to double clicking on each item in 4 calendars.