Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/252565

From BetaArchive Wiki

Article ID: 252565

Article Last Modified on 10/9/2003



APPLIES TO

  • Microsoft Outlook 2000 Standard Edition



This article was previously published under Q252565

SYMPTOMS

After you import a list of contacts from a Microsoft Excel worksheet, you notice that more Contact forms are created than the number of records in the Excel worksheet.

CAUSE

You defined individual ranges for the data elements in the Excel worksheet.

RESOLUTION

Define one named range for the data you want to import from Excel.

MORE INFORMATION

Import Results with Individual Data Ranges

The example provides three data elements to demonstrate the result described in the "Symptoms" section.

This table represents data in an Excel worksheet. The alphanumeric characters are cell references. In the table, John is in cell A2; Doe is in cell B2, and someone1@microsoft.com is in cell C2.

        A                   B                  C    

1  First Name           Last Name            E-mail
2  John                    Doe            someone1@microsoft.com
3  Mary                   Smith           someone2@microsoft.com
4  Bill                   Jones           someone3@microsoft.com
                


If ranges are defined for each column of individual data, you will import nine Contact forms, one Contact form for each range. One set of three forms contains the first names, one set of three contains Last names and the final set contains e-mail addresses.

To Correctly Define Data Ranges

Define a single range for all data to be imported. The range in the example would be A1:C4.

NOTE: The range must include the header row which defined the field names for the data, and it may be necessary to map fields from the imported data to matching fields in Outlook.

REFERENCES

For additional information about importing data from Microsoft Excel, click the article number below to view the article in the Microsoft Knowledge Base:

196743 OL2000: Importing from Microsoft Excel Requires Named Range


For more information about mapping custom fields during an Outlook import, click Microsoft Outlook Help on the Help menu, type map custom fields in the Office Assistant or the Answer Wizard, and then click Search to view the topic.



Additional query words: OL2K

Keywords: kbprb KB252565