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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
convert excel spreadheet to Outlook Contacts (address book)
have excel spreadsheet in formatted cloumns I need to load into Contacts
|
#2
|
|||
|
|||
convert excel spreadheet to Outlook Contacts (address book)
|
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|