Outlook 2007- import contacts from excel spreadsheet????

[Jeanne G.]

I have saved my contacts in an Excel 97-2003 spreadsheet with 1st row titles
i.e. Name, address. I have tried naming ranges by individual columns and by
naming the range as the whole spreadsheet. In the wizard, after choosing
Excel 97-03 and next, it tells me I need to define the ranges. I can't even
get to mapping. What can I do?

 

[Karl Timmermans]

An alternative option

Outlook & Excel - Importing from/Exporting To
http://www.contactgenie.com/blog/?p=75

Karl
--
____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - QuickPort/DataPort/Exporter/Toolkit/Duplicate Contact Mgr
"Contact import/export/data management tools for Outlook '2000/2010"
http://www.contactgenie.com

 

[Diane Poremsky [MVP]]

Save as CSV and import - no named ranges needed.

If you want to use named ranges, see
http://www.slipstick.com/tutorials/import/import.htm

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

How many email accounts are in your main Outlook profile?
http://forums.slipstick.com/showthread.php?t=36602

 

[Brian Tillman [MVP-Outlook]]

I have saved my contacts in an Excel 97-2003 spreadsheet with 1st row titles
i.e. Name, address. I have tried naming ranges by individual columns and by
naming the range as the whole spreadsheet. In the wizard, after choosing
Excel 97-03 and next, it tells me I need to define the ranges. I can't even
get to mapping. What can I do?

I can't think of too many reasons why you'd want to export your contacts as an
Excel spreadsheet and then import them back into Outlook.\

How did you name the range? Describe your exact process.