Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Import email list in excel file (http://www.outlookbanter.com/outlook-using-contacts/90467-import-email-list-excel-file.html)

Rich Stone May 17th 09 10:46 PM

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.

Karl Timmermans May 17th 09 10:57 PM

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.





All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com