convert excel spreadheet to Outlook Contacts (address book)

[Ira D.Levy]

have excel spreadsheet in formatted cloumns I need to load into Contacts

 

[Brian Tillman [MVP-Outlook]]

have excel spreadsheet in formatted cloumns I need to load into Contacts

As long as you map the columns properly and choose the correct named range,
Outlook will gladly import from an Excel spreadsheet into Contacts.

 

[Leonid S. Knyshov // SBS Expert]

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

 

[TRich]

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

Thank you.

TRich

 

[Gordon]

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

Yahoo has very good Help on this. Look there.

 

[Leonid S. Knyshov // SBS Expert]

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

Thank you.

Go to your Yahoo mail account
Click on Contacts
Click on Tools and select Export
The rest is self-explanatory
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you