Microsoft Outlook 2007 has some useful calendaring features for people with several calendars. One feature allows you to view calendars side-by-side. There are also times when I need to overlay or even merge multiple Outlook calendars. Overlaying Outlook Calendars. These days, it’s not uncommon for people to have multiple calendars.
Copying appointments from list view is fairly easy, if monotonous, but a macro makes quick work of it. This question on Outlook forums finally nudged me to write a macro that would do it:.
The result is a set of macros pulled from macros previously published here at Slipstick. (Not a lot of writing involved!) The macros that I tweaked to copy the appointments from the selected calendars were originally published at. The macro deletes the calendar called Print, if it exists, then creates a new calendar folder named Print, then checks to see if one or more calendars are selected in the navigation pane, and if so, it copies the appointments to the Print calendar. My sample copies appointments for the next 3 days, but you can add (or subtract) from Date to include any period. The data file name (as seen in the folder list) is added to each appointment as a category, so you know which calendar each appointment is from (I use category colors that match the calendar color).
Recurring appointments are copied to the Print calendar as single appointments. After running the macro, go into File, Print, click Print Options and select the Print calendar then click Print. Note: this code was updated on July 15 2014 to create the Print calendar automatically.
If the print calendar exists, it deletes it and recreates it, otherwise it creates it. It was updated on July 29 2014 to check each group for selected calendars. Updated October 27 2015 to create new items on the Print calendar instead of copying them. It's slower but avoids 'copy:' added to meeting subjects and seems to work better when there are a lot of items to copy. The code is only using the subject, start and end dates from the original appointment but other fields can be added.
August 25 2016: Added code to delete the Print calendar from Deleted Items (otherwise it errors if there are more than 10 Print calendars in the Deleted Items folder.) Calendars in Exchange Public folders are categorized using 'Favorites', not their actual folder name. You can include the calendar name when creating the category: calName = CalFolder.Parent.Name & '-' & CalFolder.Name To use the macro, paste it into the VBA Editor then click in PrintCalendarsAsOne macro and click Run (F5). If you want to run it using a button on the ribbon or QAT, select the PrintCalendarsAsOne macro and add it to the ribbon or QAT. Tools The Calendar Printing Assistant allows you to print and customize your calendar information. It includes many often-requested printing options, including multiple calendars in one view and customizations such as fonts, colors and images. It includes ready to use templates. Additional templates are available from Microsoft: For Outlook 2007 and Outlook 2010 (32-bit).
How to use macros First: You will need macro security set to low during testing. To check your macro security in Outlook 2010 or 2013, go to File, Options, Trust Center and open Trust Center Settings, and change the Macro Settings. In Outlook 2007 and older, it’s at Tools, Macro Security. Sorry i missed this earlier - i typoed the code, it should be inputbox, not plain input. Sorry about that. At the very top, with Dim CalFolder As Outlook.Folder Dim printCal As Outlook.Folder add Dim's for the dates - Dim sDate As Date Dim eDate As Date ' if using a user-defined end date After the list of Dim's in Sub PrintCalendarsAsOne add sDate = InputBox('Starting Date') 'eDate = InputBox('End Date') ' if using change sFilter as needed sFilter = 'Start = ' & sDate & ' & ' And Start.
![Outlook Outlook](http://www.microsoft.com/en-us/microsoft-365/blog/wp-content/uploads/sites/2/2017/03/Outlook-2016-for-Mac-adds-support-for-Google-Calendar-and-Contacts-1-1.png)
Hi Diane, This is great - I am using to combine multiple family calendars. It works great, but I can't get the categories to show on the newly created Print calendar - the option just isn't there on the Appointment ribbon or when I right click on the appointment itself (which it is for my other calendars). I can see the appointment has been allocated the category of it's 'parent' calendar when I open the appointment properties, but the 'Categories' descriptor is greyed out on this too.
Can you help?
Microsoft Outlook has provided the capability to work with multiple calendars in a single installation of Outlook since at least Outlook 97. However, in Outlook 2003, new functionality was added that makes this feature far more practical and easy to use. By Kara Monroe Microsoft Outlook has provided the capability to work with multiple calendars in a single installation of Outlook since at least Outlook 97. However, in Outlook 2003, new functionality was added that makes this feature far more practical and easy to use for families sharing a single installation of Outlook, employees sharing a computer, or just an individual who needs to manage multiple calendars in an easy to use format. This easy to use viewing format is the new feature that is only available on Outlook 2003. All of the other items discussed below can be used with Outlook 2000, 2002/XP, and 2003. Where different steps are required for each version, those will be provided.
WHY CREATE MULTIPLE CALENDARS? You might wonder why you would want to have more than one calendar in Outlook. If you search for Multiple Calendars in Office Help, you will get instructions for printing a blank calendar. This is one nice reason to create a second calendar.
If you need a paper calendar that is blank, you can create a second, blank calendar and print this calendar in any view. But, this is a limited view of the possibilities of the use of multiple calendars. Here are a few of my favorite uses for multiple calendars:. A calendar named vacation schedules can be used to track the vacation schedules of your staff members without clogging up your own calendar. A calendar named office schedule can be used to set the schedule for an office that must be covered at all times by individuals working a variety of hours. A calendar named after a project you are working on can be utilized to plan a project before you place all of the items on your own calendar.
My favorite – I create a My Trip calendar for any vacation I’m taking so I can list flight times, planned activities, and other items. $$PAGE$$ BEFORE YOU PLAN, YOU SHOULD KNOW While Office 2003 makes using Multiple Calendars a bit easier, there is still a long way to go before this feature is truly as helpful as it could be. For example, there is no way to simply merge two calendars. This would be very efficient in the third and fourth examples above. In both of these examples, the created calendar could allow you to continuously tweak the project or trip plan without cluttering up your primary calendar. I’d love to be able to merge these quickly from the created calendar to my primary calendar once everything is set. There is no easy way to do this.
You can move items from one calendar to another by dragging and dropping, but be careful! Calendar items dragged from one calendar to another calendar will stay in the location where dropped, not necessarily on the time and date that item was listed on the created calendar. Check the times and dates carefully to make sure no dates or times get changed. Each calendar can be separately customized. This means you can set a different font and font size for each calendar or change the time interval (15-minute, 30-minute, etc.) for each calendar. To access these features, right-click the Calendar you want to change and select “Other Settings” from the menu. You can not set different background colors for each calendar – another feature that would further extend the functionality and ease of use of this feature.
![Calendar Calendar](http://thesweetsetup.com/wp-content/uploads/2015/05/full-window.jpg)
If you just want to see groupings of your appointments and events then consider using Categories within a single calendar. For example, any travel events (air, hotel or car bookings) could be assigned to a category then viewed separately or color coded. Now that you’ve been warned against the possible problems you could encounter in using multiple calendars, let’s take a look at how to create and work with multiple calendars.$$PAGE$$ CREATING MULTIPLE CALENDARS.
Creating Multiple Calendars is a simple process. Follow these steps if you are using Outlook 2000 or 2002/XP:. Be sure your Folder List is showing. If the Folder List is not showing, select Folder List from the View menu.
Right-click Calendar in the Folder List and select New Folder. Give your second calendar a descriptive name. The “Folder Contains:” drop-down list should already say Calendar Items. If it doesn’t, select Calendar Items from the list. In the “Select where to place the folder” list, Calendar will be selected by default. Leaving the default will make your new calendar a sub-folder under Calendar.
If you’d prefer it to be listed as a “top-level” item rather than a sub folder item, select Personal Folders. Your calendar has now been created.
To view this calendar, click the name of the calendar from the Personal Folders list. Follow these steps to create a second calendar if you are using Office 2003:. Click the Calendar button from the Outlook Bar. Right-click the area just under the “My Calendars” heading on the left. Select New Folder.
Follow steps 3 – 5 above. Regardless of which version of Outlook you are using, you can also create a second calendar by clicking the drop down arrow just to the right of the New button on the standard Outlook toolbar and selecting Folder from the menu. Once you’ve selected folder, follow steps 3 through 5 from the instructions for Outlook 2000 and 2002/XP.$$PAGE$$ VIEWING TWO CALENDARS AT ONCE While Office 2003 makes it easy to view multiple calendars at the same time, it wasn’t impossible utilizing earlier versions of Outlook. We’ll look at earlier versions first and then conclude with Outlook 2003. In earlier versions of Outlook, you’ll again need to be able to see your folder list.
Remember that you can open the folder list from the View menu in Outlook. Then follow these steps:. In the folder list, select one of the two calendars you want to view. In the folder list, right click the second calendar you want to view. Select Open in New Window from the menu. The calendar will now open in a second window.
The easiest way to see these two calendars side by side is to right-click the Windows task bar and select “Tile Windows Vertically.” (Note that if you have more than just these two windows open, you may want to close extra windows prior to completing this step.) In Outlook 2003, this step can be accomplished much more easily. In Office 2003, go to the Calendar area. Under My Calendars check the calendars you want to see. The calendars are now displayed side-by-side. In Outlook 2003, you can right-click the area under “My Calendars” and select the Move Up in List or Move Down in List to change the order of your calendars in this list. If you would prefer than one of the calendars not show in this list you may also select Remove from My Calendars. This does not delete the calendar – you can still access it from the folder list – it only removes it from the My Calendars view.
See Also.