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

Chapter 19. Importing and Exporting Outl... > Importing from an Excel Worksheet

Importing 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, then choose Insert, move the pointer onto Name, and choose Define to open the Define Name dialog box. Enter a name for the range into the Names in Workbook box, and choose OK. Choose 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