Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.5 released

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





Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.