[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2688
  • Last Modified:

All Outlook Appointments to ical or vcal

We are migrating all of our users completely off of our exchange server pretty soon here to Oracle-based calendar.

I am trying to figure out a way to export, convert, and then import entire calendars instead of doing it one appointment at a time.  Outlook 2003 will only export to PST, CSV, TXT when you try to do the entire calendar.  You can open an appointment and do a "Save As" as to a iCal or vCal format, but that could be inefficient and time consuming for those that have a large amount of appointments.  For those of you that don't know, Oracle calendar will only import iCal or vCal appointments.

Ideally, I would like to be able to export the entire calendar into a file such as CSV or TXT and be able to map certain fields.  Then run that file through a utility that converts it into iCal or vCal, and finally import all of that into the Oracle calendar.

I've tried Outport, OutlookExport, and a few others but they generally did not work very well.  I'm looking for something that's pretty reliable and is not going to cause any errors.

Any ideas or alternative suggestions?  Thanks!
0
dpsit
Asked:
dpsit
  • 3
1 Solution
 
David LeeCommented:
Greetings, dpsit.

I'm confused.  You said "Outlook 2003 will only export to PST, CSV, TXT when you try to do the entire calendar" as if that's not what you want, then say "Ideally, I would like to be able to export the entire calendar into a file such as CSV or TXT and be able to map certain fields".  The two statements appear to contradict each other.  I'm also confused about the title which says "Appointments to ical or vcal" although you say you want CSV or TXT.  Can you clarify?

Cheers!
0
 
dpsitAuthor Commented:
Hah, sorry about that, that is worded pretty poorly.

"Ideally, I would like to export the entire calendar into a file such as CSV or TXT" (yes, this is a capability and I have done this)

"and be able to map certain fields" (another capability that Outlook already has)

Where I need help is to take that CSV or TXT and convert it to one or many iCal or vCal files.  I was quick to type the title... but generally I want all of a user's outlook appointments to end up as iCal or vCal without having to save them separately (which is a pain)

Let me know if you need anything else.  Thanks!
0
 
David LeeCommented:
I understand.  The code below will do exactly what you've described.  Follow these instructions to use it.

1.  Start Outlook
2.  Click Tools->Macro->Visual Basic Editor
3.  If not already expended, expand Modules and click on Module1
4.  Copy the macro and paste it into the right-hand pane of the VB editor window
5.  Edit the code as needed.  I placed a comment line immediately before where soemthing needs to change
6.  Click the diskette icon on the toolbar to save the changes
7.  Close the VB Editor
8.  Click Tools->Macro->Security
9.  Change the Security Level to Medium
10.  Go to Contacts and click on a contact.
11.  Click on the calendar folder and run the macro.  It'll export all the appointments on the calendar to iCal files.


Sub ExportToiCal()
    Dim olkFolder As Outlook.Items, _
        olkAppointment As Outlook.AppointmentItem, _
        intCount As Integer
    intCount = 1
    Set olkFolder = Application.ActiveExplorer.CurrentFolder.Items
    For Each olkAppointment In olkFolder
        'Edit the path and filename on the following line as needed
        olkAppointment.SaveAs "C:\eeTesting\Appointments\Appt-" & intCount & ".ical", olICal        'or olVcal if you prefer
        intCount = intCount + 1
    Next
    Set olkAppointment = Nothing
    Set olkFolder = Nothing
    MsgBox "All done."
End Sub
0
 
David LeeCommented:
Any update, dpsit?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now