• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Importing and Exporting Outl... > Importing Information from an Excel ...

Importing Information from an Excel Worksheet

To import information from an Excel worksheet into Outlook, the information must be in a named range. Also, the top row of the named range must contain field names that correspond to Outlook field names.

To create a named range in an Excel worksheet, select the block of cells you want to have in the range, select Insert, move the pointer onto Name, and select Define to open the Define Name dialog box. Enter a name for the range into the Names in Workbook box, and then click OK. Select File, Save to save the workbook with the named range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint