Access referencing data from Outlook Calendar

[Shem K]

Hi guys.

This is a converse to the discussion in this link, with focus on post #5 and #6:
http://bytes.com/topic/access/answer...scheduled-date

I'm doing some research on it online at the moment. If I'm unsuccessful, I'd let the database work with Outlook automation, as per the solution in the above thread.

Kind regards,

[zmbd]

Same thought as you've already done...

Create your outlook instance. (Application Automation)

   ' If Outlook is open, use GetObject, otherwise open Outlook
    Set objOutlook = GetObject(, "Outlook.Application")
    If objOutlook Is Nothing Then Set objOutlook = CreateObject("Outlook.Application")

Once you have the instance started then setup a pointer to the calendar folder with restrictions for date

set objCalendarItems = objOutlook.getdefaultfolder(olFolderCalendar)
zstrRestrictto = "[Start] <= & _
   zEnddate & "AND [End] >=" & zStartDate

Excellent example here:
(( See here too: Search the Calendar for Appointments that Occur Partially or Entirely in a Given Time Period ))