Tuesday, 15 June 2010

Import & Export via Excel

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)
This will allow for quick checking of calendars between different profiles

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)

6. A window will open that prompts you to select the date range to export. Make sure the beginning and ending dates capture all the items that you want to export

7. Close Outlook

8. Open Outlook and when prompted choose your original profile (NOT the new one you just created)

9. Import the Excel file (File>Import and Export>Import from another program or file>Microsoft Excel>browse to the Excel file you just created, highlight and click OK. When you see "Select destination folder" select your Sports calendar)

10. Click Finish and you're done


Source: articlesbase

No comments:

Post a Comment