Import contacts from Excel to Outlook

Last update on March 17, 2009 04:58 AM by jak58
Published by jak58

Import contacts from Excel to Outlook






Issue


How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items?

Solution


By using the software Excel 2000 and Outlook 2000


Method
  • When you are in the Excel file: add a column "Category" and put in "professional" or anything else, when it corresponds to a category in Outlook
  • Appoint its range cell
  • Open Outlook Express



If you do not want all these items to be spited in the "Contacts",create in it a specific folder and follow the import procedure, but do not forget to do the mapping by clicking on the button " custom fields"and to associate the category field of the file to the Outlook.
  • After the successful import, create a mailing list in the new folder containing the imported contacts
  • For select the new members, look in the Contacts folder by sorting by category: display all new
  • Select the first and the last contacts holding Shift key: it selects all the
  • Click on "Add"
Best answers for « Import contacts from Excel to Outlook » in :
Synchronise iphone contact with outlook Show Synchronise iphone contact with outlook Solution For Microsoft Vista For Windows XP Configure iTunes When you try to sync contacts, email and / or timing of your iPhone / iPod touch on a PC with Outlook, iTunes displays the...
Save/Import your Messenger contacts Show Save/Import your Messenger contacts Save the list of contacts Import contact list Always make a backup of your contact list, it’s very useful when creating a new account Messenger, or in case of crash account (yes! This can happen)....
IPhone: Import contacts from SIM Show iPhone: Import contacts from SIM How to transfer data from the address book of an SIM card? To import contacts from a SIM card, follow these steps: Insert the SIM card, In Settings, choose "Mail, Contacts, Calendar" Then choose...
Microsoft Office Outlook - How to Import & Export your e-mai ShowMicrosoft Office Outlook - How to Import & Export your e-mails? Issue Solution Issue You are buying a new PC/Laptop or Re-installing windows as you are having some problems with windows but you want to keep all your e-mails on...
Using Outlook with your Yahoo! Mail ShowUsing Outlook with your Yahoo! Mail Step 1: Configuration of your Yahoo! account Step 2: Check that the account is working It is now possible to use your Outlook account to with your Yahoo! paid subscription email accounts that...
Unable to open attachment with Outlook Express ShowUnable to open attachment with Outlook Express E-mail attachment is one of the main sources of virus infection of computer’s system. When receiving e-mail attachment with outlook express. Outlook may prevent you from opening the...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
They need your help