1. Select the data you want to export and create a named (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) range of cells.

   How?

   1. Select the range of cells that you want to name.
   2. Click the Name box at the left end of the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.).

      

      Name box

   3. Type the name for the cells.
   4. Press ENTER.

   Note  You cannot name a cell while you are changing the contents of the cell.

2. Close the workbook that contains the range you want to export.
3. Start Outlook.
4. On the File menu, click Import and Export.
5. In the Import a File Wizard, click Import from another program or file, and then click Next.
6. In the Select file type to import from box, click Microsoft Excel, and then click Next.
7. Click Browse, select the file you want to import, click OK, and then click Next.
8. Select the Contacts folder and click Next.
9. If necessary, map fields from the file you are importing to Outlook fields.

   How?

   1. Click Map Custom Fields.
   2. In the From box, drag the field you want to convert onto the Microsoft Outlook field listed in the To box.
      • If you want to see additional records in the From box, click Previous or Next.
      • If you want to remove all mapping, click Clear Map.
      • If you want to reset the original mapping, click Default Map.
   3. To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the + next to Business Address.
   4. If no field exists in the To box that would accommodate a field you are importing, you can create a new custom field. Click Add a Custom Field, and specify the field name in the New Field dialog box. You can create as many custom fields as you need.
   5. Click OK.
10. Click Finish.

1. Start Outlook.
2. On the File menu, click Import and Export.
3. Click Export to a file, and then click Next.
4. In the Create a file of type box, click Microsoft Excel, and then click Next.
5. In the Select folder to export from box, click Contacts, and then click Next.

   Note  To import only the contacts you want, you can copy them to a new folder in Outlook, and then click that folder. For more information, see Outlook Help.

6. In the Save exported file as box, specify a path and a name for the file, and then click Next.
7. If necessary, map fields from the file you are exporting to Excel.

   How?

   1. Click Map Custom Fields.
   2. In the From box, drag the field you want to convert onto the Microsoft Excel field listed in the To box.
      • If you want to see additional records in the From box, click Previous or Next.
      • If you want to remove all mapping, click Clear Map.
      • If you want to reset the original mapping, click Default Map.
   3. To display additional fields in the To box, click the plus sign (+) next to the field. For example, to display the Business Street and Business City fields, click the + next to Business Address.
   4. Click OK.
8. Click Finish.
9. In Excel, open the file you created.

Note  If you want to create a Microsoft Word mail merge from your Outlook contacts, you can do so without importing the contacts into Excel. Microsoft Word 2002 or later can access your contacts directly from Outlook. For more information, see Word Help.