Outlook/MAPI address book – field mapping in OpenOffice.org


OOo Column Name

Mozilla/OOo Attribute

Outlook Column name

Outlook MAPI Propery name

Comment
















First Name

FirstName

First Name

PR_GIVEN_NAME_W


Last Name

LastName

Last Name

PR_SURNAME_W


Display Name

DisplayName

Full Name

PR_DISPLAY_NAME_W


Nickname

NickName

Nickname

PR_NICKNAME_W


E-mail

PrimaryEmail

E-mail

PR_EMAIL_ADDRESS_W


E-mail (2)

SecondEmail




Mail Format

PreferMailFormat




Phone (Work)

WorkPhone

Business Phone

PR_BUSINESS_TELEPHONE_NUMBER_W


Phone (Home)

HomePhone

Home Phone

PR_HOME_TELEPHONE_NUMBER_W


Fax

FaxNumber

Business Fax

PR_BUSINESS_FAX_NUMBER_W


Pager

PagerNumber

Pager

PR_PAGER_TELEPHONE_NUMBER_W


Mobile

CellularNumber

Mobile

PR_MOBILE_TELEPHONE_NUMBER_W


Address 1

HomeAddress

Home Address

PR_HOME_ADDRESS_STREET_W

First line

Address 2

HomeAddress2

Home Address

PR_HOME_ADDRESS_STREET_W

Remainder

City

HomeCity

Home City

PR_HOME_ADDRESS_CITY_W


State

HomeState

Home State/Province

PR_HOME_ADDRESS_STATE_OR_PROVINCE_W


ZIP/Postal (Home)

HomeZipCode

Home ZIP/Postal Code

PR_HOME_ADDRESS_POSTAL_CODE_W


Country

HomeCountry

Home Country/Region

PR_HOME_ADDRESS_COUNTRY_W


Work Address

WorkAddress

Business Address

PR_BUSINESS_ADDRESS_STREET_W

First Line

Work Address 2

WorkAddress2

Business Address

PR_BUSINESS_ADDRESS_STREET_W

Remainder

City (Work)

WorkCity

Business City

PR_BUSINESS_ADDRESS_CITY_W


State (Work)

WorkState

Business State/Province

PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W


ZIP/Postal (Work)

WorkZipCode

Business ZIP/Postal Code

PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W


Country (Work)

WorkCountry

Home Country/Region

PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W


Job Title

JobTitle

Title

PR_TITLE_W


Department

Department

Department

PR_DEPARTMENT_W


Company

Company

Company

PR_COMPANY_NAME_W


Web Page 1

WebPage1

Web Page Address

PR_BUSINESS_HOME_PAGE_W


Web Page 2

WebPage2


PR_PERSONAL_HOME_PAGE_W


Birth Year

BirthYear

Birthday

PR_BIRTHDAY (year)

derived

Birth Month

BirthMonth

Birthday

PR_BIRTHDAY (month)

derived

Birth Day

BirthDay

Birthday

PR_BIRTHDAY (day)

derived

Custom 1

Custom1




Custom 2

Custom2




Custom 3

Custom3




Custom 4

Custom4




Comments

Notes

Comments

PR_COMMENT_W








_AimScreenName





LastModifiedDate