Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2010, 10:35 AM
sharke sharke is offline Exporting multiple calendars to CSV file Windows 7 Exporting multiple calendars to CSV file Office 2007
Novice
Exporting multiple calendars to CSV file
 
Join Date: Sep 2010
Posts: 7
sharke is on a distinguished road
Default Exporting multiple calendars to CSV file

I have a large number of calendars which are sub-items of my main calendar. Every week I have to export each calendar by appointment name and location to a CSV file for processing. The problem is that there seems to be no obvious way to export them all at once.



If I'm exporting them to a .pst file, the dialog gives me the option to "include all subfolders." However this option is missing when exporting to other file types. Which means that I have to export each calendar manually - a real chore, especially as the export tool doesn't even have a date selector to select a range, I have to enter the start and end dates manually.

I've tried a couple of add-ons which allow one to export multiple calendars to CSV, unfortunately they either didn't allow for a date range to be specified, or they didn't allow the mapping of fields and exported everything. My processing requires that I only have the name and location, nothing more.

Does anyone know of an add-on which can do this, or alternatively a convenient workaround to achieve what I'm looking for?
Reply With Quote
  #2  
Old 09-06-2010, 11:14 AM
Technician Technician is offline Exporting multiple calendars to CSV file Windows XP Exporting multiple calendars to CSV file Office 2003
Banned
 
Join Date: Oct 2009
Location: Canada
Posts: 44
Technician is on a distinguished road
Default

1. Open Outlook
2. Click File menu
3. Click Import and Export
4. Click Export to a file
5. Click Comma Separated Values (Windows)
Quote:
You may be required to install the possible translator here. Just follow the directions on the screen.
6. Select folder to export from: Calendar
7. Browse, name, and save the file some place easy to find it. (Desktop)
8. Click Next
Quote:
Outlook will prompt you to specify the start and end date of the period which should be exported
9. On the follow actions will be performed screen click the Finish button.
Reply With Quote
  #3  
Old 09-06-2010, 07:40 PM
sharke sharke is offline Exporting multiple calendars to CSV file Windows 7 Exporting multiple calendars to CSV file Office 2007
Novice
Exporting multiple calendars to CSV file
 
Join Date: Sep 2010
Posts: 7
sharke is on a distinguished road
Default

Hi Admin,

Thanks for the reply but I think you misunderstood the question. I already know how to export individual calendars to a CSV file - what I'm looking to do is export all of my calendars to a single CSV file in one step. Like I said, you can multi-select calendars when you export to .pst but not when you're exporting to other file types (which seems a little bizarre).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting multiple calendars to CSV file Can you stop multiple calendars from fading? JohnGalt Outlook 2 08-05-2010 09:06 AM
Outlook '07 & Multiple Calendars patski107 Outlook 0 03-05-2010 08:01 PM
Exporting to PDF and keeping file size down CloudandBanner Word 0 08-24-2009 09:29 AM
How can I save multiple email messages to a file folder? (crosspost) tupham Outlook 0 08-04-2008 07:56 PM
Outlook 2003 drops notes when exporting as a VCARD file GY58 Outlook 0 04-29-2006 07:57 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft