Outlook Data Fields
The proper data field titles are required to set any
criteria on Outlook® data. Below are the
available fields. Examples are also
shown below. Not all fields have been
tested. Be creative and be sure to test
the criteria before counting on it to work.
CONTACT FIELDS
- Account
- Anniversary
- AssistantName
- AssistantTelephoneNumber
- BillingInformation
- Birthday
- Business2TelephoneNumber
- BusinessAddressCity
- BusinessAddressCountry
- BusinessAddressPostalCode
- BusinessAddressPostOfficeBox
- BusinessAddressState
- BusinessAddressStreet
- BusinessFaxNumber
- BusinessHomePage
- BusinessTelephoneNumber
- CallbackTelephoneNumber
- CarTelephoneNumber
- Categories
(a category of RADSync is added to all Slave items)
- Children
- Companies
- CompanyMainTelephoneNumber
- CompanyName
- ComputerNetworkName
- CustomerID
- Department
- FileAs
- FirstName
- FormDescription
- FTPSite
- FullName
- Gender
- GovernmentIDNumber
- Hobby
- Home2TelephoneNumber
- HomeAddressCity
- HomeAddressCountry
- HomeAddressPostalCode
- HomeAddressPostOfficeBox
- HomeAddressState
- HomeAddressStreet
- HomeFaxNumber
- HomeTelephoneNumber
- Importance
- Initials
- InternetFreeBusyAddress
- ISDNNumber
- JobTitle
- Journal
- Language
- LastName
- ManagerName
- MessageClass
- MiddleName
- Mileage
- MobileTelephoneNumber
- NetMeetingServer
- NickName
- NoAging
- OfficeLocation
- OrganizationalIDNumber
- OtherAddressCity
- OtherAddressCountry
- OtherAddressPostalCode
- OtherAddressPostOfficeBox
- OtherAddressState
- OtherAddressStreet
- OtherFaxNumber
- OtherTelephoneNumber
- PagerNumber
- PersonalHomePage
- PrimaryTelephoneNumber
- Profession
- RadioTelephoneNumber
- SelectedMailingAddress
- Sensitivity
- Spouse
- Subject
- Suffix
- TelexNumber
- Title
- TTYTDDTelephoneNumber
- Unread
- User1
- User2
- User3
- User4
- UserCertificate
- WebPage
- YomiCompanyName
- YomiFirstName
- YomiLastName
- CreationTime
- EntryID
- LastModificationTime
These will cause a security dialog if you do not have Outlook
Redemption (will halt an automatic scan)
- Email1Address
- Email2Address
- Email3Address
- NetMeetingAlias
- Body
(Note
- ReferredBy
Usable only by Outlook 2002 and up
- Email1AddressType
- Email1DisplayName
- Email2AddressType
- Email2DisplayName
- Email3AddressType
- Email3DisplayName
- IMAddress
APPOINTMENT FIELDS
- AllDayEvent
- ReminderSet
- ResponseRequested
- IsRecurring
- BusyStatus
- Importance
- MeetingStatus
- ReminderMinutesBeforeStart
- Sensitivity
- ConversationIndex
- ConversationTopic
- Location
- Subject
- Categories
(a category of RADSync is added to all Slave items)
- End
(cant be used with Data Sync or Import/Export because it is already used
to set scope)
- ReplyTime
- Start
(cant be used with Data Sync or Import/Export because it is already used
to set scope)
- Companies
These are only available if the appointment is recurring
- DayOfMonth
- DayOfWeekMask
- Duration
- Endtime
- Instance
- Interval
- MonthOfYear
- NoEndDate
- Occurrences
- PatternEndDate
- PatternStartDate
- RecurrenceType
- Regenerate
- StartTime
This will cause a security dialog if you do not have Outlook Redemption (will halt an automatic scan)
TASKS and NOTES coming soon…
EXAMPLES
Use SQL style filtering
[Categories] = ‘Work’
[Gender] = ‘Male’
[Subject] <> ‘’ (subject not blank)
[LastModificationTime] >= ‘01/01/2005’
[Birthday]
<> ‘’ and [Children]
<> ‘’
[Gender] = ‘Male’ or [Mileage] <> ‘’
The not equal (<>) will not work well for the
Categories field since it can have multiple categories. For example if a Contact is categorized as
“Work” and “Friend” then a filter of [Categories] <> ‘Friend’ will
include this contact since ‘Work’ <> ‘Friend’.
Return to the main page
Roll-A-Desktop
Website