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

Article translations Article translations
Article ID: 2567286 - View products that this article applies to.
Expand all | Collapse all

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.

Properties

Article ID: 2567286 - Last Review: September 4, 2013 - Revision: 3.0
Applies to
  • Microsoft Outlook 2010
  • Microsoft Outlook 2010 with Business Contact Manager
Keywords: 
KB2567286

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com