OutlookTools

This page is still a work in progress.

The OutlookTools UDF offers some often needed extended functionality to control and manipulate Microsoft Outlook. It is built on top of the OutlookEX UDF.

General

Most of the functions provide a callback function. It gets called before an Outlook item is created.

You decide how the item is being handled by setting the return value:

Return value	Action
0	Create the Outlook item, continue processing the next record
1	Do not create the Outlook item, continue processing the next record
2	Do not create the Outlook item, cancel processing all remaining records and exit the _OLT_* function.

The function is called with a parameter describing the data being used to create the Outlook item. This parameter is read only. The full description of this data can be found in the corresponding function you find below.

Functions

_OLT_iCal_VEventImport

Import iCal events from an ICS file to an Outlook calendar.

COMPONENT:PROPERTY	SECTION IN RFC 5545	OUTLOOK PROPERTY	COMMENT
VEVENT:CATEGORIES	Section 3.8.1.2.	Categories
VEVENT:CLASS	Section 3.8.1.3.	Sensitivity	olNormal, olPrivate or olConfidentional. olPersonal does not get set
VEVENT:DESCRIPTION	Section 3.8.1.5.	Body
VEVENT:LOCATION	Section 3.8.1.7.	Location
VEVENT:PRIORITY	Section 3.8.1.9.	Importance
VEVENT:SUMMARY	Section 3.8.1.12.	Subject
VEVENT:DTEND	Section 3.8.2.2.	End	specifies the non-inclusive end of the event
VEVENT:DTSTART	Section 3.8.2.4.	Start	Example
VEVENT:DURATION	Section 3.8.2.5.	End	used to calculate the end property
VEVENT:TRANSP	Section 3.8.2.7.	BusyStatus
VALARM:TRIGGER	Section 3.8.6.3.	ReminderMinutesBeforeStart	Only the minutes section of the duration is processed

Callback function parameter

xxx

_OLT_vCard_Import

Import vCard contacts to an Outlook contacts folder.

Callback function parameter

xxx

_OLT_CSV_Import

Imports data from a CSV file and creates Outlook items in a specified folder.

Callback function parameter

xxx