What Can You Do with Outlook's Fields? Outlook 2003 provides a large number of fields that can be used when creating Outlook forms and VBA solutions. However, this appendix is not only for developers. To best utilize Outlook, you need to understand how Outlook stores information. Outlook is very similar to a database. It has structures similar to tables (folders) and structures similar to records (items). A large number of fields are contained within Outlook. Some of those fields are available in multiple items and folders, and some are very specific, appearing in only one particular item type. This appendix lists just about every field available in Outlook. You can see data type, field name, and description for each field. Use this appendix as a resource when developing your own applications or when simply trying to understand how Outlook works. Table G.1 lists a large number of the fields available in Outlook. Sometimes the field name in Outlook's Field Chooser is different from the actual Outlook Object Model property. Be sure to examine both columns to determine how you should reference your desired field. NOTE You can use Outlook field information when developing your own applications or when using the Advanced Find feature. TIP For a visual representation of the Outlook Object Model, go to the MSDN home page at http://msdn.microsoft.com and search for the Outlook Object Model. Although not every property or method is listed here, a visual representation of the Object Model can help you understand the relationships between the different Outlook objects. For more information about developing custom applications with Outlook, see "Creating and Using Custom Forms," p. 757, "Using VBA in Outlook 2003," p. 797, and "Advanced Outlook Programming Topics," p. 821. For more information about the Advanced Find feature, see "Using the Advanced Find Function," p. 530. Table G.1. Outlook Fields and PropertiesField Name | Object Model Property | Data Type | Writable |
---|
% Complete | PercentComplete | Number | Yes | Account | Account | Text | Yes | Actual Work | ActualWork | Duration | Yes | Address Selected | No equivalent field | Reserved | No | Address Selector | No equivalent field | Reserved | No | All Day Event | AllDayEvent | Yes/No | Yes | Anniversary | Anniversary | Date/Time | Yes | Assigned | DelegationState | Number | No | Assistant's Name | AssistantName | Text | Yes | Assistant's Phone | AssistantTelphoneNumber | Text | Yes | Attachment | Attachments | Yes/No | No | Bcc | BCC | Text | Yes | Billing Information | BillingInformation | Text | Yes | Birthday | Birthday | Date/Time | Yes | Business Address | BusinessAddress | Text | Yes | Business Address City | BusinessAddressCity | Text | Yes | Business Address Country | BusinessAddressCountry | Text | Yes | Business Address PO Box | BusinessAddressPostOfficeBox | Text | Yes | Business Address Postal Code | BusinessAddressPostalCode | Text | Yes | Business Address State | BusinessAddressState | Text | Yes | Business Address Street | BusinessAddressStreet | Text | Yes | Business Fax | BusinessFaxNumber | Text | Yes | Business Home Page | BusinessHomePage | Text | Yes | Business Phone | BusinessTelephoneNumber | Text | Yes | Business Phone 2 | Business2TelephoneNumber | Text | Yes | Callback | CallbackTelephoneNumber | Text | Yes | Car Phone | CarTelephoneNumber | Text | Yes | Categories | Categories | Text | Yes | CC | CC | Text | Yes | Changed By | No equivalent property | Text | No | Children | Children | Text | Yes | City | HomeAddressCity | Text | Yes | Color | Color | Number | Yes | Comments | Comments | Text | No | Company | Companies | Text | Yes | Company Main Phone | CompanyMainTelephoneNumber | Text | Yes | Company Name | CompanyName | Text | Yes | Complete | Complete | Yes/No | Yes | Computer Network Name | ComputerNetworkName | Text | Yes | Contact | FormDescription.ContactName | Text | Yes | Contacts | Links | Text | Yes | Content | Body | Text | Yes | Conversation | ConversationTopic | Text | No | Country | HomeAddressCountry | Text | Yes | Created | CreationTime | Date/Time | No | Customer ID | CustomerID | Text | Yes | Date Completed | DateCompleted | Date/Time | Yes | Defer Until | DeferredDeliveryTime | Date/Time | Yes | Department | Department | Text | Yes | Distribution List Name | DLName | Text | No | Do Not AutoArchive | NoAging | Yes/No | No | Download State | No equivalent property | Text | No | Due By | FlagDueBy | Date/Time | Yes | Due Date | DueDate | Date/Time | Yes | Duration | Duration | Text | No | E-Mail | Email1Address | Text | Yes | E-Mail 2 | Email2Address | Text | Yes | E-Mail 3 | Email3Address | Text | Yes | E-Mail Selected | No equivalent property | Text | Yes | E-Mail Selector | No equivalent property | Text | Yes | End | End | Date/Time | Yes | Entry Type | Type | Text | No | Expires | ExpiryTime | Date/Time | No | File As | FileAs | Text | Yes | First Name | FirstName | Text | Yes | Flag Status | FlagStatus | Number | No | Follow-Up Flag | FlagRequest | Yes/No | No | From | SentOnBehalfOfName | Text | No | FTP Site | FTPSite | Text | Yes | Full Name | FullName | Text | Yes | Gender | Gender | Text | Yes | Government ID Number | GovernmentIDNumber | Text | Yes | Have Replies Sent To | ReplyRecipientsNames | Text | No | Hobbies | Hobby | Text | Yes | Home Address | HomeAddress | Text | Yes | Home Address City | HomeAddressCity | Text | Yes | Home Address Country | HomeAddressCountry | Text | Yes | Home Address PO Box | HomeAddressPostOfficeBox | Text | Yes | Home Address Postal Code | HomeAddressPostalCode | Text | Yes | Home Address State | HomeAddressState | Text | Yes | Home Address Street | HomeAddressStreet | Text | Yes | Home Fax | HomeFaxNumber | Text | Yes | Home Phone | HomeTelephoneNumber | Text | Yes | Home Phone 2 | Home2TelephoneNumber | Text | Yes | Icon | FormDescription.Icon | Object | No | Importance | Importance | Number | Yes | In Folder | Parent | Text | No | Initials | Initials | Text | Yes | Internet Free Busy Address | InternetFreeBusyAddress | Text | Yes | ISDN | ISDNNumber | Text | Yes | Job Title | JobTitle | Text | Yes | Journal | Journal | Yes/No | Yes | Junk E-Mail Type | No equivalent property | Text | No | Language | Language | Text | Yes | Last Name | LastName | Text | Yes | Last Saved Time | No equivalent property | Date/Time | No | Location | Location | Text | Yes | Mailing Address | MailingAddress | Text | No | Mailing Address Indicator | No equivalent property | Text | No | Manager's Name | ManagerName | Text | Yes | Meeting Status | MeetingStatus | Number | No | Message | Body | Text | Yes | Message Class | MessageClass | Text | No | Message Flag | FlagStatus | Text | Yes | Middle Name | MiddleName | Text | Yes | Mileage | Mileage | Text | Yes | Mobile Phone | MobileTelephoneNumber | Text | Yes | Modified | LastModificationTime | Date/Time | No | Nickname | NickName | Text | Yes | Notes | Body | Text | Yes | Office Location | OfficeLocation | Text | Yes | Optional Attendees | OptionalAttendees | Text | Yes | Organizational ID Number | OrganizationalIDNumber | Text | Yes | Organizer | Organizer | Text | No | Other Address | OtherAddress | Text | Yes | Other Address City | OtherAddressCity | Text | Yes | Other Address Country | OtherAddressCountry | Text | Yes | Other Address PO Box | OtherAddressPostOfficeBox | Text | Yes | Other Address Postal Code | OtherAddressPostalCode | Text | Yes | Other Address State | OtherAddressState | Text | Yes | Other Address Street | OtherAddressStreet | Text | Yes | Other Fax | OtherFaxNumber | Text | Yes | Other Phone | OtherTelephoneNumber | Text | Yes | OutlookInternal Version | OutlookInternalVersion | Text | No | Outlook Version | OutlookVersion | Text | No | Owner | Owner | Text | No | Pager | PagerNumber | Text | Yes | Personal Home Page | PersonalHomePage | Text | Yes | Phone n Selected | No equivalent property | Text | Yes | Phone n Selector | No equivalent property | Text | Yes | PO Box | HomeAddressPostOfficeBox | Text | Yes | Primary Phone | PrimaryTelephoneNumber | Text | Yes | Priority | Importance | Number | No | Private | Sensitivity | Number | Yes | Profession | Profession | Text | Yes | Radio Phone | RadioTelephoneNumber | Text | Yes | Read | Unread | Yes/No | No | Received | ReceivedTime | Date/Time | No | Recurrence | RecurrencePattern RecurrenceType | Number | No | Recurrence Pattern | No equivalent property | Text | No | Recurrence Range End | RecurrencePattern. PatternEndDate | Date/Time | No | Recurrence Range Start | RecurrencePattern. PatternStartDate | Date/Time | No | Recurring | IsRecurring | Yes/No | No | Referred By | ReferredBy | Text | Yes | Remind Beforehand | ReminderMinutesBeforeStart | Number | Yes | Reminder | ReminderSet | Yes/No | No | Reminder Override Default | ReminderOverrideDefault | Yes/No | No | Reminder Sound | ReminderPlaySound | Yes/No | Yes | Reminder Sound File | ReminderSoundFile | Text | Yes | Reminder Time | ReminderTime | Date/Time | No | Reminder Topic | No equivalent property | Text | No | Remote Status | RemoteStatus | Number | No | Requested By | No equivalent property | Text | Yes | Required Attendees | RequiredAttendees | Text | Yes | Resources | Resources | Text | Yes | Response Requested | ResponseRequested | Yes/No | Yes | Retrieval Time | No equivalent property | Number | No | Role | Role | Text | Yes | Send Plain Text Only | No equivalent property | Yes/No | No | Sensitivity | Sensitivity | Number | No | Sent | SentOn | Date/Time | No | Show Time As | BusyStatus | Number | Yes | Size | Size | Number | No | Spouse | Spouse | Text | Yes | Start | Start | Date/Time | Yes | Start Date | StartDate | Date/Time | Yes | State | HomeAddressState | Text | Yes | Status | Status | Number | No | Street Address | HomeAddressStreet | Text | Yes | Subject | Subject | Text | Yes | Suffix | Suffix | Text | Yes | Team Task | TeamTask | Yes/No | Yes | Telex | TelexNumber | Text | Yes | Title | Title | Text | Yes | To | To | Text | Yes | Total Work | TotalWork | Number | Yes | Tracking Status | TrackingStatus | Number | No | TTY/TDD Phone | TTYTDDTelephoneNumber | Test | Yes | User Field 1 | User1 | Text | Yes | User Field 2 | User2 | Text | Yes | User Field 3 | User3 | Text | Yes | User Field 4 | User4 | Text | Yes | Web Page | WebPage | Text | Yes | ZIP/Postal Code | HomeAddressPostalCode | Text | Yes | |