Using ClipForm with Appointment, Task and Journal Items

You can use CLIPFORM to extract data from Microsoft Outlook appointments, tasks and journal items.  This is useful for creating calendars, appointment lists, time sheets, to-do lists, etc.

IMPORTANT NOTE CONCERNING APPOINTMENTS.  CLIPFORM will automatically include recurring appointments – but only if you specify filters for the earliest and the latest start date.  The reason for this is that otherwise the collection would include all recurrences of an appointment – potentially, an infinite number.  Thus, if you wanted to extract all appointments occurring within the next 30 days, you would need to include the following filters:

[Filter=Start>=Today]

[Filter=Start<=Today+30]

If you do not specify filters for both the earliest and latest start dates, then CLIPFORM will ignore occurrences of recurring appointments.

Microsoft Outlook is capable of storing a wealth of appointment, task and journal data data.  With CLIPFORM, it's easy to extract this data into the format you choose.

Below is a listing of the data fields which Microsoft Outlook includes for appointments, task and journal items.  All of these are string items, except those highlighted which are boolean, date/time, numeric or special – click the links for information on how to specify the formatting for those values.

CLIPFORM also supports pseudo-fields Date, Time and DateTime, for intelligently handling dates and times for appointments that include timed appointments, single-day all-day appointments, and multi-day all-day appointments.  The Date field includes the date (for single-day and timed appointments) and the date range (for multi-day appointments).  The Time field provides the start and end time for timed appointments, and returns a blank for all-day (untimed) appointments.  The DateTime field combines these two, to produce a single date (no time), a date range (no time), or date and starting/ending times, depending on whether the appointment is an all-day appointment, a multi-day appointment, or a timed appointment.  Moreover, if the starting and ending time are the same, only the start time will be included.