Managing Your Business with Outlook 2003 for Dummies 8. Trong cuốn sách này, các bạn có thể biết cách làm thế nào để tổ chức, lãnh đạo nhóm của bạn và doanh nghiệp của bạn bằng cách tạo ra các thủ tục cho các mục tiêu kiểm soát, thông tin liên lạc thông qua e-mail, kiểm soát bán hàng, hoạt động tiếp thị, nhiệm vụ, và chia sẻ thông tin. | Chapter 4 Creating an Awesome Customers and Suppliers Database 51 Troubleshooting Excel import problems In the past importing Excel files to older Outlook versions without the proper Excel file configuration started an endless process of importing empty fields until the computer went down. Fortunately Outlook 2003 warns of the translation error see figure . There are two ways of solving the problem quickly one for people who are not so familiar with Excel and a second for Excel users. Solving the no named ranges problem quickly Open the Excel file and save it as . Then start the import again for the new text file. See the section Importing noncompatible files earlier in this chapter. Fixing the Excel file to solve the problem To prepare the Excel file select the entire database inside Excel including the headings and all the data and then choose Insert1 -Name to give the area range a name. Using this procedure solves the import problem with Outlook. Start the import again with the new Excel file. See the section Importing noncompatible files earlier in this chapter. Figure 4-3 The Map Custom Fields dialog box. 8. Drag and drop the desired fields from the Value list to the Mapped From list. 52 Part II Managing Contact Information In the example the field Name was mapped to the First Name field in Outlook. The field Name is seen now in the Mapped From column. Figure 4-3 shows the result. 9. Repeat Step 8 for all the desired fields in the Value list see Figure 4-4 . 10. After you finish mapping all the values click OK. You return to the Import A File dialog box 11. Click Finish. Figure 4-4 When importing from incompatible files map the incoming fields to Outlook s Contacts fields. The Import Progress window appears. After the import is complete click the Contact button on the Outlook Navigation Pane to see the imported contacts. Going Beyond Your Little Black Book Ten years ago not everybody had an e-mail address a Web site and an instant .
