|
| 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
May 17th 09, 10:46 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Import email list in excel file
Sorry if this has been asked before but I couldn't find it...
I have a long list of emails in an Excel 2003 file and want to add them to my contacts in Outlook 2007. I have tried using the import function but I keep getting a message saying the excel file has 'no named ranges' and to 'Use Excel to name the range of date to be imported'. I'm not sure what this means. 
|
| Ads |
|
#2
May 17th 09, 10:57 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Import email list in excel file
You basically have 2 choices:
#1 - Review "Named Ranges" in the Excel help file and apply as required OR #2 - save your worksheet as a CSV file and import that file into Outlook instead (fastest route to your destination) Regardless of which choice you make - be sure to manually map your fields (or at least verify what Outlook has mapped for you depending on the field names in use in your Excel file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Rich Stone" wrote in message ... Sorry if this has been asked before but I couldn't find it... I have a long list of emails in an Excel 2003 file and want to add them to my contacts in Outlook 2007. I have tried using the import function but I keep getting a message saying the excel file has 'no named ranges' and to 'Use Excel to name the range of date to be imported'. I'm not sure what this means.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Automatically email an Excel file to a Distribution List | Claire | Outlook and VBA | 1 | August 29th 08 03:29 PM |
| import email addesses from excel into Outlook distribution list? | Rod | Outlook - Using Contacts | 1 | April 17th 08 02:57 PM |
| How do I import contact info from Excel into email dist list? | Delrae | Outlook - Using Contacts | 1 | August 1st 07 01:38 PM |
| How do I import an excel file into Calendar? | Kent McLellan | Outlook - Calandaring | 2 | June 7th 06 07:37 PM |
| excel file type missing from import a file window in outlook | xanadufl | Outlook - Using Contacts | 9 | February 28th 06 09:55 AM |
Linear Mode
