Full Listing

How to import address information from an Excel workbook into my Contacts list in Microsoft Outlook
View The Full Article
Follow the steps below to import Excel data into Outlook: 1. Arrange the Excel data in the traditional database format i.e., give each column field titles and make each row a record. 2. Change the field titles in the worksheet so that they match those in your Outlook Contacts list. 3. To display the Name dialog box, press CtrlF3. Use this dialog box to assign the name Contacts to the entire range of contacts data. 4. Open Outlook, and from the File menu, select Import and Export... . 5. In Outlook 2003 or 2007, select Import from another program or file. Click Next. 6. Select Microsoft Excel. Click Next. Note: You may get the following prompt: Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now If you do, click Yes to continue. 7. From the Import a File page, make your desired selections, depending on how you want to handle duplicates. To navigate to the Excel file you are importing, click Browse... . 8. Select the file, then click OK. Back in the Import a File dialog box, click Next. 9. In the Select a destination folder window, select the Contacts folder. Click Next. 10. On this last page, you will see two buttons: Map Custom Fields... : Click if you want to change the field mapping, i.e., the selection of which columns in your Excel file match up with which data in Outlookand39s contacts. For example, one of your Excel file columns might read Home, and youand39ll have to map that in Outlook to either Home Address or Home Phone, accordingly. Change Destination... : Click if you want to change the destination folder. Since you are importing contacts, and since you already selected the destination folder in the last step, you only need to click this button if you made a mistake or want to doublecheck that youand39ve selected the right one. Otherwise, you can ignore it. When you are done, click Finish, and wait for Outlook to complete the task. To check the results in Outlook, open your Contacts folder.