View Single Post
  #4  
Old March 1st, 2010, 03:44 PM posted to microsoft.public.outlook.contacts
Trich
external usenet poster
 
Posts: 2
Default convert excel spreadheet to Outlook Contacts (address book)

Can I import my contact list from a Yahoo account? If so, what are the steps?

Thank you.

TRich

"Leonid S. Knyshov // SBS Expert" wrote:

On 2/24/2010 11:58 AM, Ira D.Levy wrote:
have excel spreadsheet in formatted cloumns I need to load into Contacts

One quick way to this:

1. Click File - Import/Export to export current contacts into a
CSV.(Comma Separated Values (Windows))
2. Load the CSV into Excel
3. Delete all data from that file except for top headers. You can do
this by placing the cursor into the A2 field, and then pressing
Ctrl-shift-end to select everything to the end of file, and then just
press Delete.
4. Paste your existing data into matching columns
5. Close the CSV file (avoids file sharing conflict)
6. Use File - Import feature of Outlook to import this data

By following these steps, you'll eliminate the need to map fields.

Outlook 2007 does not like to import from Excel 2007 xlsx files.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you
.