A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

convert excel spreadheet to Outlook Contacts (address book)



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2010, 08:58 PM posted to microsoft.public.outlook.contacts
Ira D.Levy
external usenet poster
 
Posts: 1
Default convert excel spreadheet to Outlook Contacts (address book)

have excel spreadsheet in formatted cloumns I need to load into Contacts
  #3  
Old February 26th, 2010, 07:40 AM posted to microsoft.public.outlook.contacts
Leonid S. Knyshov // SBS Expert
external usenet poster
 
Posts: 290
Default convert excel spreadheet to Outlook Contacts (address book)

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
  #4  
Old March 1st, 2010, 04: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
.

  #5  
Old March 1st, 2010, 05:27 PM posted to microsoft.public.outlook.contacts
Gordon[_13_]
external usenet poster
 
Posts: 3,406
Default convert excel spreadheet to Outlook Contacts (address book)


"TRich" wrote in message
...
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.

  #6  
Old March 1st, 2010, 07:04 PM posted to microsoft.public.outlook.contacts
Leonid S. Knyshov // SBS Expert
external usenet poster
 
Posts: 290
Default convert excel spreadheet to Outlook Contacts (address book)

On 3/1/2010 7:44 AM, TRich wrote:
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.