How to tell the difference between field names in an Outlook 2003 contact list and in a Word 2003 mail merge (818851)



The information in this article applies to:

  • Microsoft Office 2003, All Editions
  • Microsoft Office Outlook 2003
  • Microsoft Office Word 2003

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

Fields Not Available

The following are the Outlook Contact fields that 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                                                                                         

Modification Type:MajorLast Reviewed:3/23/2006
Keywords:kbemail kbinfo kbprb KB818851 kbAudEndUser