You cannot map custom fields when you import an XLS or CSV file in the Hebrew version of Outlook 2010

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:

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.
hebrew, arabic, outlook 2010, import wizard, contact information
Properties

Article ID: 2567286 - Last Review: 09/04/2013 10:30:00 - Revision: 3.0

Microsoft Outlook 2010, Microsoft Outlook 2010 with Business Contact Manager

  • KB2567286
Feedback