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
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 | |
Display Modes | |
|
|