CalendarSharing.SaveAsICal Method (Outlook)
The level of detail provided in the iCalendar file is determined by a combination of values in the following CalendarSharing properties:
You can set the IncludeWholeCalendar property to True to export all items contained in the folder, or you can set the StartDate and EndDate properties to limit the exported items to a date range between a specified start date and end date, respectively.
The following Visual Basic for Applications (VBA) example creates a CalendarSharing object for the Calendar folder, then exports the contents of the entire folder (including attachments and private items) to an iCalendar calendar (.ics) file.
Public Sub ExportEntireCalendar() Dim oNamespace As NameSpace Dim oFolder As Folder Dim oCalendarSharing As CalendarSharing On Error GoTo ErrRoutine ' Get a reference to the Calendar default folder Set oNamespace = Application.GetNamespace("MAPI") Set oFolder = oNamespace.GetDefaultFolder(olFolderCalendar) ' Get a CalendarSharing object for the Calendar default folder. Set oCalendarSharing = oFolder.GetCalendarExporter ' Set the CalendarSharing object to export the contents of ' the entire Calendar folder, including attachments and ' private items, in full detail. With oCalendarSharing .CalendarDetail = olFullDetails .IncludeWholeCalendar = True .IncludeAttachments = True .IncludePrivateDetails = True .RestrictToWorkingHours = False End With ' Export calendar to an iCalendar calendar (.ics) file. oCalendarSharing.SaveAsICal "C:\SampleCalendar.ics" EndRoutine: On Error GoTo 0 Set oCalendarSharing = Nothing Set oFolder = Nothing Set oNamespace = Nothing Exit Sub ErrRoutine: Select Case Err.Number Case 287 ' &H0000011F ' The user denied access to the Address Book. ' This error occurs if the code is run by an ' untrusted application, and the user chose not to ' allow access. MsgBox "Access to Outlook was denied by the user.", _ vbOKOnly, _ Err.Number & " - " & Err.Source Case -2147467259 ' &H80004005 ' Export failed. ' This error typically occurs if the CalendarSharing ' method cannot export the calendar information because ' of conflicting property settings. MsgBox Err.Description, _ vbOKOnly, _ Err.Number & " - " & Err.Source Case -2147221233 ' &H8004010F ' Operation failed. ' This error typically occurs if the GetCalendarExporter method ' is called on a folder that doesn't contain calendar items. MsgBox Err.Description, _ vbOKOnly, _ Err.Number & " - " & Err.Source Case Else ' Any other error that may occur. MsgBox Err.Description, _ vbOKOnly, _ Err.Number & " - " & Err.Source End Select GoTo EndRoutine End Sub