
April 27th 06, 10:31 AM
posted to microsoft.public.outlook.calendaring
|
|
how do i print off a monthly report of meetings in outlook
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.
|