Import contact info from excel to Outlook 2003 withing XP envrironment

[Lynn]

I have attempted name the columns of contact info in
excell with a colunar header that describes the type of
informaiton, i.e. phone no, address, person name, etc.

When I attempt to import from excel to an Outlook folder,
the named ranges show up individualy but the mapping
button is not avaialble. Instead, individual check boxes
are noted beside each named range. If the import is
allowed to complete, each indivual named range is
imported, but not integrated together whereby each
contact has all its information in one file. Instead,
each named range is imported as if a separate contact,
i.e. address, phone numbers, names, etc.

When I attempt to reset or define the named ranges in
excel, a pop up error box citing MAPI error 0x80070057
appears with no options avaialble. The import processing
is halted.

It appears that I need help in accurately naming the
excell data ranges arranged by columns so that importing
can proceed.

I have now cleard the name of each range in excel via the
INSERT - NAMES - DEFINE options.

Any help is appreciated.

 

[Iggy]

Try the following:
1. Close your excel file
2. From Outlook go to File, Import and Export, Export to a
File, Excel File... and give a name for that File
3. Open your first excel file
4. Copy and paste column by column from your first file to
the corresponding column in the new file. This is because
the colunar header must have the same name.
5. Once you have copied and pasted to the corresponding
column, save and close.
6. Go to Outlook, and do the Import process again. The Map
soptiopn should now appear, do the mapping and finish.
That should work

 

[Karl Timmermans]

Two things you can do -

First is to export your excel sheet to a CSV file and import that - that way
you don't have to worry about "named ranges".

The second is to simply delete all your existing "named ranges" in your
Excel sheet - then highlight all the data you want to import including the
header row - give that a single range name. You should have no problems
importing the file at that point.

Karl

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com