Google Git
Sign in
apache / openoffice-org / bae4ea485ebbd5dfd1014f061bb06a0954836b4b / . / content / dba / FAQ / Outlook_field_mapping.html
blob: d47670c0ce51ca9c31551deb36a38102e4eaaafa [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<head>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
<TITLE>Outlook/MAPI address book &ndash; field mapping in OpenOffice.org</TITLE>
<META NAME="GENERATOR" CONTENT="StarOffice 6.1 Beta 1 (Win32)">
<META NAME="CREATED" CONTENT="20020205;11525300">
<META NAME="CHANGED" CONTENT="20030131;8450314">
<STYLE>
<!--
TD P { color: #000000; font-family: "Albany" }
P { color: #000000; font-family: "Albany" }
H2 { color: #000000 }
-->
</STYLE>
</head>
<body LANG="en-US" TEXT="#000000" DIR="LTR">
<H2 STYLE="margin-top: 0cm; margin-bottom: 0cm; page-break-before: always">
<FONT COLOR="#cc3300"><FONT FACE="Times New Roman, serif"><FONT SIZE=5><B>Outlook/MAPI
address book &ndash; field mapping in OpenOffice.org</B></FONT></FONT></FONT></H2>
<P STYLE="margin-bottom: 0cm"><BR>
</P>
<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=2 CELLSPACING=0 STYLE="page-break-before: always">
<COL WIDTH=38*>
<COL WIDTH=46*>
<COL WIDTH=46*>
<COL WIDTH=100*>
<COL WIDTH=26*>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT><B>OOo Column Name</B></P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><B>Mozilla/OOo Attribute</B></P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><B>Outlook Column name</B></P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT><B>Outlook MAPI Propery name</B></P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><B>Comment</B></P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>First Name</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>FirstName</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>First Name</P>
</TD>
<TD WIDTH=39%>
<P>PR_GIVEN_NAME_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Last Name</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>LastName</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Last Name</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_SURNAME_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Display Name</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>DisplayName</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Full Name</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_DISPLAY_NAME_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Nickname</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>NickName</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Nickname</P>
</TD>
<TD WIDTH=39%>
<P>PR_NICKNAME_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>E-mail</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>PrimaryEmail</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>E-mail</P>
</TD>
<TD WIDTH=39%>
<P>PR_EMAIL_ADDRESS_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>E-mail (2)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>SecondEmail</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Mail Format</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>PreferMailFormat</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Phone (Work)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkPhone</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business Phone</P>
</TD>
<TD WIDTH=39%>
<P>PR_BUSINESS_TELEPHONE_NUMBER_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Phone (Home)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomePhone</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home Phone</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_HOME_TELEPHONE_NUMBER_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Fax</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>FaxNumber</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business Fax</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_BUSINESS_FAX_NUMBER_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Pager</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>PagerNumber</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Pager</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_PAGER_TELEPHONE_NUMBER_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Mobile</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>CellularNumber</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Mobile</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_MOBILE_TELEPHONE_NUMBER_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Address 1</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeAddress</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home Address
</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_STREET_W</P>
</TD>
<TD WIDTH=10%>
<P>First line</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Address 2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeAddress2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home Address</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_STREET_W</P>
</TD>
<TD WIDTH=10%>
<P>Remainder</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>City</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeCity</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home City</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_CITY_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>State</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeState</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home State/Province</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_STATE_OR_PROVINCE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>ZIP/Postal (Home)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeZipCode</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home ZIP/Postal Code</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_POSTAL_CODE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Country</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>HomeCountry</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home Country/Region</P>
</TD>
<TD WIDTH=39%>
<P>PR_HOME_ADDRESS_COUNTRY_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Work Address
</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkAddress</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business Address</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_BUSINESS_ADDRESS_STREET_W</P>
</TD>
<TD WIDTH=10%>
<P>First Line</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Work Address 2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkAddress2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business Address</P>
</TD>
<TD WIDTH=39%>
<P>PR_BUSINESS_ADDRESS_STREET_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT>Remainder</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>City (Work)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkCity</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business City</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_BUSINESS_ADDRESS_CITY_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>State (Work)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkState</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business State/Province</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>ZIP/Postal (Work)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkZipCode</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Business ZIP/Postal Code</P>
</TD>
<TD WIDTH=39%>
<P>PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Country (Work)</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WorkCountry</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Home Country/Region</P>
</TD>
<TD WIDTH=39%>
<P ALIGN=LEFT>PR_BUSINESS_ADDRESS_STATE_OR_PROVINCE_W</P>
</TD>
<TD WIDTH=10%>
<P ALIGN=LEFT><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Job Title</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>JobTitle</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Title</P>
</TD>
<TD WIDTH=39%>
<P>PR_TITLE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Department</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Department</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Department</P>
</TD>
<TD WIDTH=39%>
<P>PR_DEPARTMENT_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Company</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Company</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Company</P>
</TD>
<TD WIDTH=39%>
<P>PR_COMPANY_NAME_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Web Page 1</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WebPage1</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Web Page Address</P>
</TD>
<TD WIDTH=39%>
<P>PR_BUSINESS_HOME_PAGE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Web Page 2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>WebPage2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P>PR_PERSONAL_HOME_PAGE_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Birth Year</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>BirthYear</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Birthday</P>
</TD>
<TD WIDTH=39%>
<P>PR_BIRTHDAY (year)</P>
</TD>
<TD WIDTH=10%>
<P>derived</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Birth Month</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>BirthMonth</P>
</TD>
<TD WIDTH=18%>
<P>Birthday</P>
</TD>
<TD WIDTH=39%>
<P>PR_BIRTHDAY (month)</P>
</TD>
<TD WIDTH=10%>
<P>derived</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Birth Day</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>BirthDay</P>
</TD>
<TD WIDTH=18%>
<P>Birthday</P>
</TD>
<TD WIDTH=39%>
<P>PR_BIRTHDAY (day)</P>
</TD>
<TD WIDTH=10%>
<P>derived</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Custom 1</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Custom1</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Custom 2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Custom2</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Custom 3</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Custom3</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Custom 4</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Custom4</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT>Comments</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Notes</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>Comments</P>
</TD>
<TD WIDTH=39%>
<P>PR_COMMENT_W</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P><BR>
</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>_AimScreenName</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
<TR>
<TD WIDTH=15% HEIGHT=16>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT>LastModifiedDate</P>
</TD>
<TD WIDTH=18%>
<P ALIGN=LEFT><BR>
</P>
</TD>
<TD WIDTH=39%>
<P><BR>
</P>
</TD>
<TD WIDTH=10%>
<P><BR>
</P>
</TD>
</TR>
</TABLE>
<P STYLE="margin-bottom: 0cm"><BR>
</P>
</body>
</HTML>