|
| 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 | Search this Thread | Display Modes |
|
#1
February 24th 10, 07:58 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
convert excel spreadheet to Outlook Contacts (address book)
have excel spreadsheet in formatted cloumns I need to load into Contacts
|
| Ads |
|
#2
February 24th 10, 09:41 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
convert excel spreadheet to Outlook Contacts (address book)
|
|
#3
February 26th 10, 06:40 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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
March 1st 10, 03:44 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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
March 1st 10, 04:27 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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
March 1st 10, 06:04 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to convert Contacts to address book | Gabbytony | Outlook - Using Contacts | 1 | March 14th 08 09:38 AM |
| I can't convert contacts to outlook address book. | JBD | Outlook - Using Contacts | 2 | August 27th 07 02:14 PM |
| Will contacts convert to address book outlook 2007 trial version | chortrdh | Outlook - Using Contacts | 3 | May 19th 07 01:14 AM |
| Importing Contacts from excel, they don't appear in Address Book | Kathleen Maloney | Outlook - Using Contacts | 3 | September 24th 06 05:21 PM |
| how do I get my contacts from excel to show up in my address book | Houston Texas | Outlook - Using Contacts | 10 | February 22nd 06 01:07 AM |
Linear Mode
