If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Outlook 2007- import contacts from excel spreadsheet????
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? |
#2
|
|||
|
|||
Outlook 2007- import contacts from excel spreadsheet????
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 "Jeanne G." wrote in message ... 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? |
#3
|
|||
|
|||
Outlook 2007- import contacts from excel spreadsheet????
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 Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: How many email accounts are in your main Outlook profile? http://forums.slipstick.com/showthread.php?t=36602 "Jeanne G." wrote in message ... 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? |
#4
|
|||
|
|||
Outlook 2007- import contacts from excel spreadsheet????
"Jeanne G." wrote in message
... 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. -- Brian Tillman [MVP-Outlook] |
Thread Tools | |
Display Modes | |
|
|