Prerequisites:
The following applies to Outlook 2003 although this method will work for Outlook 2007 as well.
This method also assumes that you have Microsoft Excel installed and you have created a custom calendar in Outlook.
Problem: Suppose you’ve gone to your favorite teams website and downloaded the season schedule as a vcs file. And let’s assume you have created a custom calendar called Sports and you want to import the downloaded calendar file into your custom Sports folder. By default the items will be imported into your Outlook default calendar NOT your Sports folder.
Solution 1:
Drag & Drop from your default calendar
You could import the items into your default calendar then drag and drop them into your Sports folder. However this can get tedious when dealing with a large number of items across many different dates.
Solution 2:
Import & Export via Excel
1. Create a new Outlook profile (Control Panel>Mail>Show Profiles>Add>create your new profile and you can put in a real email address or just a fake one as only the calendar will be used)
2: Change Outlook to prompt for a profile when starting up (Control Panel>Mail>Show Profiles>Prompt for a profile to be used)
3. Start Outlook and when prompted, select the new profile that you created
4. Import the calendar file into Outlook (File>Import and Export>Import an iCalendar or vCalendar (.vcs) file>browse to the calendar file you want to import, highlight and click OK. Open the calendar and verify that all the items were imported successfully.
5. Export the calendar file (File>Import and Export>Export to a file>Microsoft Excel>Calendar>Give the file a name and make sure it’s saved as an Excel file with the .xls file extension
