Most fields in Microsoft Outlook store simple text data, and Clipform extracts this data as simple text. However, some Microsoft Outlook data consists of dates and times, numbers, and boolean (true/false) values. Clipform offers outstanding flexibility in how to format this data. For each date/time, boolean or numeric Outlook field, you can optionally follow the field with a vertical bar and a format specification, as the examples below show.

Format strings for dates and times should be specified as shown below.

• mmmm Month (full spelling), e.g. April
• mmm Month (text, abbreviated), e.g. Apr
• mm Month (numeral with leading zero), e.g. 04
• m Month (numeral without leading zero), e.g. 4
• dddd Day of the week (full spelling), e.g. Wednesday
• ddd Day of the week (abbreviated), e.g. Wed
• dd Day of the month (numeral with leading zero), e.g. 05
• d Day of the week (numeral without leading zero), e.g. 5
• yyyy Year (all digits), e.g. 2001
• yy Year (two digits), e.g. 01
• hh Hour (24 hour format)
• h Hour (12 hour format)
• mm Minutes
• ss Seconds
• ampm am or pm (12 hour time format)

[Start|ddd. mm/dd/yy h:mm ampm] Sat. 04/28/01 12:30 pm
[CreationTime|dddd, mmmm d, yyyy] Saturday, April 28, 2001

Format strings for dates and times should be specified as shown below.

• ### Digit placeholder; leave blank if no significant digit present.
• 000 Digit placeholder; include a zero if no significant digit present.

[Mileage|$0.00] $0.23
[Price|$##,###,000.00] $ 1,214.35

With Boolean values, you have even more flexibility: you can specify the text to use for true values, and the text to use for false values, separating them with a vertical bar. If you omit this vertical bar, then no text will be included for false values. Here are some examples:

[Newsletter|Newsletter] (Extracts Newsletter if Newsletter is true, nothing if Newsletter is false)
[AllDayEvent|Yes|No] (Extracts Yes if item is an all day event; No if it is not.)

Outlook Appointment and Journal items feature a Duration field. If you follow this field with a vertical bar and h:mm, the duration will be extracted in hours and minutes. If you omit this, duration will be extracted as minutes. For example, an item of 90 minutes duration would be extracted as follows

• [Duration|h:mm] produces: 1:30
• [Duration] produces 90

Certain Outlook values are coded references to items in a list. For example, the Gender property can be male, female or unspecified. Some of these are automatically converted by Clipform to the appropriate string:

• Sensitivity can be blank, or can be Personal, Private or Confidential
• Status (for tasks) can be Not Started, In Progress, Complete, Waiting or Deferred
• BusyStatus (for appointments) can be Free, Tentative, Busy or Out Of Office
• FlagStatus can be blank, or it can be Complete; or if an item is flagged, this will produce the FlagRequest value, if one exists; otherwise it will return Flagged

• [Gender|Female|Male] Extracts the gender, formatting it as Female or Male. If the gender is unspecified, returns a blank.
• [Gender|F|M] Extracts the gender, formatting it as F or M. If the gender is unspecified, returns a blank.
• [Importance|Low|Normal|High] Extracts the importance. The values shown û Low, Normal and High û are the Outlook defaults, but you can substitute anything.