Microsoft KB Archive/818851

= How to tell the difference between field names in an Outlook contact list and in a Word mail merge =

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

Fields that are unavailable
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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.