Article ID: 818851
Article Last Modified on 11/26/2007
APPLIES TO
- Microsoft Office Standard Edition 2003
- Microsoft Office Outlook 2003
- Microsoft Office Word 2003
- Microsoft Office Outlook 2007
- Microsoft Office Ultimate 2007
- Microsoft Office Standard 2007
- Microsoft Office Word 2007
For a Microsoft Word 2000 version of this article, see 197716.
SUMMARY
This article compares the field names that are used in a Microsoft Outlook Contact list and a Microsoft Word mail merge.
MORE INFORMATION
There are some fields in All Contact Fields in Outlook that have different names in a Word mail merge. Most fields have the same name in both Outlook and Word, but some fields that are in Outlook are not available in Word. For example, there are not any user-defined Outlook fields available in Word.
The following are the Word merge fields with their corresponding Outlook Contact fields, as they appear in the Word Insert Merge Field or Match Fields dialog boxes.
Address fields
Word Merge Field Name Outlook Contact Field Name
--------------------- --------------------------
Address 1 Street
Business Phone Business Phone
Business Fax Business Fax
City Address City (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Country Address Country (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Courtesy Title Title
First Name First Name
Last Name Last Name
Company Company
Department Department
Home_Fax Home Fax
Postal_Code Address Postal Code (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
State Address State (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Web Page Business Home Page
ZIP/Postal code Address Postal Code (only)
Business, Home or Other
depending on which is
checked as the mailing address
in the Contact Record
Database fields
Word Merge Field Name Outlook Contact Field Name
--------------------- --------------------------
Account Account
Address Street
Assistant Assistants name
Assistant_Phone_Number Assistant's phone
Business_Fax Business Fax
Business_Address Street
Business_Address_City Business Address City
Business_Address_PO_Box Business Address PO Box
Business_Address_Postal_Code Business Address Postal Code
Business_Address_State Business Address State
Business_Address_Street Street
Company Company
City City (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Country Country (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Department Department
Display_name Includes the Title, First Name, Middle Name,
Last Name, Suffix
First First Name
File_As File As
Home2_Phone Home Phone 2
Home_Address Includes:
Home Address Postal Code
Home Address City
Home Address State
Home Address Country
Home_Fax Home Fax
Journal Journal
Value field: True or False
Last Last Name
Mobile_Phone Mobile Phone
Office Office Location
Other_Fax Other Fax
Pager_Phone Pager
Phone Local Phone (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Post_Office_Box Business Address PO Box
Primary Primary Phone
State State (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
Telex_Number Telex
Title Title
User_Field_1 User Field 1
User_Field_2 User Field 2
User_Field_3 User Field 3
User_Field_4 User Field 4
Web_Page Business Home Page
ZIP/Postal code Zip/Postal Code (only)
Business, Home or Other
depending upon which is
checked as the mailing address
in the Contact Record
The following Outlook Contact fields are not available in a Word mail merge:
Address Selected Initials
Address Selector Internet Free/Busy Address
Anniversary ISDN
Attachment Job Title
Billing Information Language
Birthday Location
Business Address Mailing Address
Business Address Country Mailing Address Indicator
Business Address Street Manager's Name
Business Phone 2 Message Class
Callback Middle Name
Car Phone Mileage
Categories Modified
Children Nickname
Company Main Phone Organizational ID Number
Computer Network Name Other Address
Contacts Other Address PO Box
Created Other Address Street
Customer ID Other Phone
E-mail Outlook Internal Version
E-mail 2 Outlook Version
E-mail 3 Personal Home Page
E-mail Displayed As Phone 5 Selected
E-mail Selected Phone 5 Selector
E-mail Selector Phone 6 Selected
E-mail2 Display As Phone 6 Selector
E-mail3 Display As Phone 7 Selected
E-mail Address Type Phone 7 Selector
E-mail2 Address Type Phone 8 Selected
E-mail3 Address Type Phone 8 Selector
File As PO Box
Flag Status Private
Follow Up Flag Profession
FTP Site Radio Phone
Full Name Read
Gender Received Representing Name
Government ID Number Referred By
Hobbies Reminder
Home Address Reminder Time
Home Address PO Box Reminder Topic
Home Address Street Sensitivity
Home Phone Size
Icon Spouse
IM Address Subject
In Folder Suffix
TTY/TDD Phone
Web Page
Note The Job Title field is now available for mail merge in Microsoft Office Word 2007.
Additional query words: OFF2003 OFF2007 WD2007 OL2007
Keywords: kbinfo kbprb kbemail KB818851
