"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
Class: COutlookCalendar
Working with Microsoft Outlook Calendars through Automation
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the COutlookCalendar class
|
|
AppNameSpace
|
Property
|
Gets a handle to the current instance of the Outlook NameSpace
|
|
AppOutlook
|
Property
|
Gets a handle to the current instance of Outlook
|
|
AddAppointment
|
Method
|
Adds an appointment without attachments to the calendar
|
|
AddMeetingRequest
|
Method
|
Adds an appointment without attachments to the calendar
|
|
CancelMeetings
|
Method
|
Cancel and send cancellation notice, but do not delete all meetings with the subject name in the date range specified
|
|
Class_Terminate
|
Terminate
|
Cleanup class variables opened for Outlook
|
|
CloseOutlook
|
Method
|
Closes an instance of Outlook; don't call this if you want to leave Outlook open
|
|
DeleteAppointments
|
Method
|
Deletes all appointments with the subject name from the calendar in the date range specified
If you delete a meeting request, a cancel meeting is sent
|
|
EditAppointmentTime
|
Method
|
Change the start time of the first appointment that meets the specified subject and date range
|
|
GetAppointmentID
|
Method
|
Get the Global Appointment ID of the first Appointment Item with the specified subject
The problem with this ID is that Outlook doesn't allow searching appointments using this ID since it's stored as a binary.
|
|
GetAppointmentInfo
|
Method
|
Get the first appointment that meets the specified subject and date range, and set values from it
|
|
GetAppointmentItem
|
Method
|
Get the first appointment item the specified criteria. With the item, you can edit its properties directly.
|
|
GetCalendarFilter
|
Private
|
Create the filter string to limit the calendar items to a date range, but also include items that span the range
|
|
GetCalendarItems
|
Method
|
Gets a list of all calendar items with start dates OR end dates within the specified date range
|
|
GetMeetingRequests
|
Method
|
Get the list of meeting requests from the InBox for a specific subject and/or received date range
|
|
IsTimeAvailable
|
Method
|
Checks if there is an existing appointment within the specified date range with an option to ignore appointments flagged as free.
If no end date is passed, we just check datFromDate.
Sample Parameters and Return Values: Assuming there is an appointment scheduled from 10:00 AM until 10:30 AM:
Values Passed Return Value
---------------------------------------------------------------------
Start End
10:00 AM No value (Assume 10:01) IsAvailable = False
10:30 AM No value (Assume 10:31) IsAvailable = True
10:00 AM 10:00 AM IsAvailable = True
10:30 AM 10:30 AM IsAvailable = True
10:01 AM 10:02 AM IsAvailable = False
9:30 AM 10:00 AM IsAvailable = True
9:30 AM 10:01 AM IsAvailable = False
10:30 AM 10:31 AM IsAvailable = True
10:29 AM 10:31 AM IsAvailable = False
9:00 AM 11:00 AM IsAvailable = False
|
|
RespondToMeetingRequest
|
Method
|
Respond to the meeting requests in the Inbox for the subject and date range specified
|
|
StartOutlook
|
Method
|
Starts an instance of Outlook
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
