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 |
|
|
|
PrimaryEmail |
|
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 |
|
|
|