how do i print off a monthly report of meetings in outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
how do i get a table view?

Sue Mosher said:
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...
 
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top