combine 24 meeting room calendars in to 1 single list

Status
Not open for further replies.

s7evie

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Apologies if this has been asked a 1000 times.

At work, we have 24 meeting rooms and these are on outlook as resources and people book them as and when required by using outlook. Reception can have all 24 meeting room calendars on screen but they need to have a printed list of all meetings just in case the system crashes. Currently, they spend 30 mins every day printing each calendar and then typing up a single list of meetings based on the start time.

Is there anyway to make this simpler?
 
It would be faster to copy the day's appointments to a master calendar for printing. Use a view that shows today's appointments, select all then copy and paste into the master calendar. Print. Delete the appointments from the master calendar and repeat the next day. A macro could speed up the copy and paste.

Or you could use a print utility, like the Calendar Printing Assistant for Outlook.
 
This macro will copy appointments from a selected calendar to another calendar and adds a category for the mailbox name so you know whose calendar it is. It doesn't walk all calendars (yet), so you need to select each calendar and run it. My goal is to run it on all selected calendars in one step.

Code:
Sub CopyforPrinting()
 Dim CalFolder As Outlook.folder 
   Dim printCal As Outlook.folder 
   Dim CalItems As Outlook.Items 
   Dim ResItems As Outlook.Items 
   Dim sFilter As String 
   Dim iNumRestricted As Integer 
   Dim itm, newAppt As Object
  ' Use the selected calendar folder 
   Set CalFolder = Application.ActiveExplorer.CurrentFolder
 Set CalItems = CalFolder.Items 
   Set printCal = Session.GetDefaultFolder(olFolderCalendar).Folders("Print")
 If CalFolder = printCal Then 
   MsgBox "Can't use the same calendar for source and destination" 
   Exit Sub 
   End If
 ' Sort all of the appointments based on the start time 
   CalItems.Sort "[Start]" 
'include recurrences that fall within the date period 
   CalItems.IncludeRecurrences = True
  calName = CalFolder.Parent.Name

  'create the Restrict filter 
   sFilter = "[Start] >= '" & Date & "'" & " And [End] < '" & Date + 2 & "'"
  ' Apply the filter to the collection 
   Set ResItems = CalItems.Restrict(sFilter)
  iNumRestricted = 0
  'Loop through the items in the collection. 
   For Each itm In ResItems 
      iNumRestricted = iNumRestricted + 1 
     
 Set newAppt = printCal.Items.Add(olAppointmentItem) 
 
With newAppt 
    .Start = itm.Start 
    .End = itm.End 
    .subject = itm.subject 
    .Body = itm.Body 
    .Location = itm.Location 
    .Categories = calName '& ";" & itm.Categories 
    .ReminderSet = False 
End With 
       
 newAppt.Save
  Next 
   ' Display the actual number of appointments created 
     MsgBox (iNumRestricted & " appointments were created"), vbOKOnly, "Convert Recurring Appointments"
  Set itm = Nothing 
   Set newAppt = Nothing 
   Set ResItems = Nothing 
   Set CalItems = Nothing 
   Set CalFolder = Nothing 
  
 
End Sub
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D How To Combine Share Task Folders in just one Folder Using Outlook 0
glnz O365 - How to combine the Inboxes for four email accounts into a single Inbox Using Outlook 7
N Macro for attachment saved and combine Outlook VBA and Custom Forms 1
Diane Poremsky Combine and Print Multiple Outlook Calendars Using Outlook 0
O Combine Mail Rules Exchange Server Administration 6
W Combine Mail Merge to Distribution List with Auto Attachments - Outlook 2007 Using Outlook 1
F Combine Outlook Task Folders into one View (Outlook 2013) Using Outlook 3
D Outlook 365 Forward Meeting Related Messages to Specific Meeting Organizer Outlook VBA and Custom Forms 0
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Using Outlook 0
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Exchange Server Administration 0
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
diver864 vba for a rule to automatically accept meeting requests with 'vacation' in subject, change to all-day event, change to free, don't send reply Outlook VBA and Custom Forms 1
S Skype for business meeting vba code Outlook VBA and Custom Forms 1
A Unable to save recurring Meeting to Documents folder due to error Using Outlook 2
S Meeting with Time Slots Using Outlook 2
egarneau Meeting updates with external contacts (GMail) Using Outlook 1
L automaticaly create a teams meeting with a sync Using Outlook 0
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S Meeting Invite arrives from Wrong ("send-as") Sender Using Outlook 1
Daniel Schunk Meeting responses are not shown in the status area Using Outlook 2
A End-time meeting reminder (or "negative" time relative to the meeting start time) Using Outlook 1
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
T Pick-a-Meeting in Outlook 365 Using Outlook 2
J No response required when delegate arranging meeting Using Outlook 0
S Accepting meeting request from calendar keeps the meeting request in the inbox Using Outlook 2
D Add all meeting rooms to the meeting request by default Outlook VBA and Custom Forms 0
Rick Rickert Would like bigger meeting notifications. Using Outlook 3
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
D Next Available Meeting with Userform Variables Outlook VBA and Custom Forms 1
J Outlook 2016 shows Meeting Organizer in Calendar View Using Outlook 5
C Update Notes for Meeting Attendees Using Outlook 8
D Outlook macros to create meeting on shared calendar Outlook VBA and Custom Forms 10
P Skype contact icons have disappeared at the bottom of email and meeting objects Using Outlook 2
T Double clik behavior on agenda open a new meeting request Using Outlook 1
B How to get Meeting Invitations into Outlook.com calendar? Using Outlook 2
Diane Poremsky Autoaccept a Meeting Request using Rules Using Outlook 2
Diane Poremsky Close a Meeting When the Room is Full Using Outlook 0
A Attendee Update Outlook Meeting Invite Using Outlook 0
Diane Poremsky iPhone and the Meeting Request Bug Using Outlook 0
P Receiving a Meeting Declined notice for a recurring meeting Using Outlook 0
A Customize meeting form. Private notices Outlook VBA and Custom Forms 3
A VBA to create meeting from template from a time slot selected in someone's calendar Outlook VBA and Custom Forms 5
Diane Poremsky Meeting Location Warning Message Using Outlook 0
B Meeting Accept option greyed out Using Outlook 0
A Custom form not showing when recurrence is set for a meeting Using Outlook 0
S Meeting room booking report Outlook VBA and Custom Forms 1
Diane Poremsky How to Create a Pick-a-Meeting Request Using Outlook 0
Britonius Locate Cause of Deleted Meeting Using Outlook 0
C Problem tracking meeting responses Using Outlook 3

Similar threads

Back
Top