Outlook calendar data to SQL table

rsturner8

Member
Joined
Feb 23, 2011
Messages
6
Programming Experience
1-3
Hi, I have a task, where I need to pull the back end data from an outlook calendar into a SQL database. I would liek to build the program using VB.NET.

I have no idea on how to do this. I have connected to Active directory before usign VB.NET and would think it would be similar in terms of connecting to the exchange server to get the data.

Any code samples or genral hints or tips on how to start this project and what to look at first would be most appreciated.
Thanks
 
VB.NET:
 Dim objOutlook As Outlook.Application
    Dim objAppt As Outlook.AppointmentItem
    Dim objRecurPattern As Outlook.RecurrencePattern
    Set objOutlook = CreateObject("Outlook.Application")
    Set objAppt = objOutlook.CreateItem(olAppointmentItem)
    With objAppt
        .Start = Me.datTargetStart
        .End = Me.datProjectedCompletion
        .Subject = Me.txtProjectName
        .Location = Me.cboSystem
        If Not IsNull(Me.txtProjectNotes) Then .Body = OutlookNotes
        .Save
        .Close (olSave)
    End With
    'Release the AppointmentItem object variable.
    Set objAppt = Nothing

This is just some code I found online but you would definitely want to play around and research Outlook VBA code to get all the object names.
 
Back
Top