DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2567286 - Last Review: September 4, 2013 - Revision: 3.0

Symptoms

The Microsoft Outlook 2010 import wizard cannot import contact information from an XLS or CSV file into the Hebrew language version of Outlook 2010.

Cause

The Outlook 2010 import wizard cannot match fields because of a "right to left" localization issue. The applicable sides of the "Map Custom Fields" dialog box are reversed from the English version.

Resolution

A workaround exists to resolve this problem. It consists of editing the XLS or CSV file before you import it into Outlook 2010. To apply the workaround, follow these steps:
  1. Open the CSV file in Microsoft Excel.
  2. Open Outlook 2010 and create a new contact.
  3. Look at the fields that are available in the contact information and match the information to the fields that are written in the Microsoft Excel CSV file.
    Note: The fields in the CSV file are displayed in line 1.
  4. Replace all fields in the CSV file with the Hebrew equivalent fields in Outlook.
    Example: If cell A1 is 'First Name', replace it with 'שם פרטי'.
  5. Save your file.
  6. On the File menu in Outlook 2010, select Open.
  7. Click Import.
  8. Follow the Import and Export Wizard steps to import your file.

More information

Here is a list of some fields and their Hebrew translation:

Collapse this tableExpand this table
FieldHebrew Translation
First Nameשם פרטי
Last Nameשם משפחה
Companyחברה
Middle Nameשם שני
Titleתואר
Suffixסיומת
Email Addressדואר אלקטרוני
Workעבודה
Homeבית
Faxפקס
Mobileנייד

This article also applies to any right-to-left languages, such as Arabic.

Microsoft has confirmed that this is a known issue in the products that are listed in the "Applies To" section of this article. Please refer back to this article for updates on this issue.

Applies to
  • Microsoft Outlook 2010
  • Microsoft Outlook 2010 with Business Contact Manager
Keywords: 
KB2567286
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support