Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

import hotmail contacts to outlook

0 views
Skip to first unread message

pitbull

unread,
Sep 24, 2007, 12:50:02 PM9/24/07
to
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

unread,
Sep 24, 2007, 1:12:21 PM9/24/07
to
"pitbull" <pit...@discussions.microsoft.com> wrote in message
news:42B01249-E267-42B1...@microsoft.com...


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


Rich/rerat

unread,
Sep 24, 2007, 2:08:55 PM9/24/07
to
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>>

"Vince Averello [MVP-Outlook]" <vi...@omegageek.com> wrote in message
news:63495B99-3E3E-4878...@microsoft.com...
See if the info here helps in the definition of named ranges:
http://support.microsoft.com/kb/196743/en-us

"pitbull" <pit...@discussions.microsoft.com> wrote in message
news:42B01249-E267-42B1...@microsoft.com...

0 new messages