|
| Import contact information from Excel |
| |
If you have an Excel workbook filled with important contact information, make that workbook even more useful by importing it into Outlook. It's easy to get information from Excel to Outlook, but you'll have to prep your Excel document first. In the workbook, select the data you want to import to Outlook and name the range (select the data and then click Insert | Name | Define). Now you're ready to import:
In Outlook, click File | Import & Export.
Choose Import From Another Program Or File from the dialog box and click Next.
In the next window, Select File Type To Import From, scroll down to Microsoft Excel, highlight this selection, and click Next.
Enter the Excel filename or click Browse.
After filling in the filename to be imported, in the same window Outlook gives you the opportunity to choose how you would like to specify those records: have Outlook ignore duplicates, replace them, or allow duplicate items to be created. Select the radio button next to your choice and click Next.
Select the Contacts folder as the destination for your import and click Next.
Note: If some of the information from your Excel workbook is already in your Outlook Contacts folder, create a new Contacts folder before you begin the import process. Import the Excel workbook into that folder and eliminate the need to worry about duplicate information. |
See
TechRepublic.com and The Office Letter for tips and articles on a broad range of other topics!
|
|
