Microsoft KB Archive/167770

= OL97: Field Differences Between Outlook and Word Mail Merge =

Article ID: 167770

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Outlook 97 Standard Edition
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q167770





SUMMARY
When you use the Outlook Address Book as a data source for a mail merge in Microsoft Word 97, the Outlook 97 Contact records are converted into a file named X010 (talk)_virtual_file_X010 (talk).olk. Some Outlook fields are not available in this file and some field names are a bit different from what they are in Outlook. This article describes the Outlook fields available to Word Mail Merge and lists those that are not available.



MORE INFORMATION
A few fields in the "All Contact Fields" group in Outlook have different names in Word Mail Merge. Most have the same name in both Outlook and Word but 63 are not available in Word at all. No user-defined Outlook fields are available in Word.

NOTE: To access more Outlook Contact fields you can export the Contact folder via a comma or tab delimited file, and use that file as the Word Mail Merge data source, rather than the Outlook Address Book.

The following are the Word Merge Fields with their corresponding Outlook fields, as they appear in the Word "Insert Merge Field" list.   Word Merge Field Name     Outlook Contact Field Name -    --

Courtesy_Title           Title

First_Name               First Name

Last_Name                Last Name

Generation               Suffix

Title                    Job Title

Company                  Company

Department               Department

Postal_Address           Mailing Address (complete) - Business, Home, or Other depending upon which is                            checked in the Contact Record

Office_Location          Office Location

Street_Address           Street Address (only) Business, Home or Other depending upon which is                            checked in the Contact Record

City                     City (only) Business, Home or Other depending upon which is                            checked in the Contact Record

State_or_Province        State (only) Business, Home or Other depending upon which is                            checked in the Contact Record

Postal_Code              Zip/Postal Code (only) Business, Home or Other depending upon which is                            checked in the Contact Record

Country                  Country (only) Business, Home or Other depending upon which is                            checked in the Contact Record

Business_Phone           Business Phone

Business_Phone_2         Business Phone 2

Business_Fax             Business Fax

Assistant_Name           Assistant's Name

Assistant_Phone          Assistant's Phone

Spouse                   Spouse

Home_Phone               Home Phone

Home_Phone_2             Home Phone 2

Home_Fax                 Home Fax

Home_Street_Address      Home Address Street

Home_City                Home Address City

Home_State_or_Province   Home Address State

Home_Postal_Code         Home Address Postal Code

Home_Country             Home Address Country

Other_Phone              Other Phone

Primary_Fax              Other Fax

Other_Street_Address     Other Address Street

Other_City               Other Address City

Other_State_or_Province  Other Address State

Other_Postal_Code        Other Address Postal Code

Other_Country            Other Address Country

Mobile_Phone             Mobile Phone

Pager_Phone              Pager

Email_Name               Subject

Email_Type               Not from Contact Record

Email_Address            E-mail The following are the Outlook Contact fields NOT available in Word Mail Merge.   Outlook Contact Field Name --  Account Anniversary Attachment Biling Information Birthday Business Address Business Address City Business Address Country Business Address PO Box Business Address Street Business Home Page Callback Car Phone Categories Children Company Main Phone Computer Network Name Created Customer ID  E-mail 2 E-mail 3 File As  FTP Site Full Name Gender Government ID Number Hobbies Home Address Home Address PO Box Icon In Folder Initials ISDN Journal Language Location Manager's Name Message Class Middle Name Mileage Modified Nickname Organizational ID Number Other Address Other Address PO Box Outlook Internal Version Outlook Version Personal Home Page PO Box Primary Phone Profession Radio Phone Read Referred By  Sensitivity Size Telex TTY/TDD Phone User Field 1 User Field 2 User Field 3 User Field 4 Web Page

