import hotmail contacts to outlook

[Guest]

I am trying to export my hotmail contacts into outlook 2003. I have saved it
as a csv file but when trying to import it into outlook it says it has no
name ranges! Any ideas

 

[Gordon]

I am trying to export my hotmail contacts into outlook 2003. I have saved
it
as a csv file but when trying to import it into outlook it says it has no
name ranges! Any ideas

Open the file in Excel and do as it says - name the range!

 

[Vince Averello [MVP-Outlook]]

See if the info here helps in the definition of named ranges:
http://support.microsoft.com/kb/196743/en-us

 

[Rich/rerat]

pitbull,
1An alternitive method, is to export your contact list as a *.CSV file, and
save it on your desktop, or any other location that is easier for you to
find it. Make sure you include all the categories that it offers that you
can include for the *.CSV file, such as name, address1, email1, etc..
2. Then open the *.CSV file in Excel, and delete the data for your current
contacts, but leave the Headers for the columns in place. At this time you
might want to save the excel document as a template, if you plan to do this
often.
3. Open the second *.csv file in Excel, and copy/paste the data in the
appropriate column for each contact/record.
4. Some items may not be compatible with the Outlook format, so you will
need to work around them.
5. Save the new excel document as a *.csv file.
6. Import Contacts into Outlook using the new *.csv file.

--
Have A Good Day
Rich/rerat

Add MS to your News Reader: news://msnews.microsoft.com
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>

See if the info here helps in the definition of named ranges:
http://support.microsoft.com/kb/196743/en-us