|
| 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 | Search this Thread | Display Modes |
|
#1
March 4th 10, 10:01 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
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? 
|
| Ads |
|
#2
March 4th 10, 10:14 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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
March 4th 10, 11:04 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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
March 5th 10, 12:59 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2003/2007 importing data from an excel spreadsheet into contacts | BobR | Outlook - General Queries | 2 | February 26th 08 04:00 PM |
| How do you export 2007 outlook contacts to an excel spreadsheet? | Brian | Outlook - Using Contacts | 1 | June 5th 07 10:07 PM |
| How do I import addresses from an Excel Spreadsheet into Outlook? | Neil | Outlook - General Queries | 4 | March 6th 07 11:16 PM |
| How do I import contact info from an excel spreadsheet to outlook | CLF8475 | Outlook - Using Contacts | 2 | September 8th 06 02:31 AM |
| Import contacts from excel spreadsheet | Sharon @ Flag Fen | Outlook - Using Contacts | 1 | May 9th 06 01:35 PM |
Linear Mode
