Outlook: Setting up Excel Named Ranges to Import into Outlook

I'm trying to import a file from Microsoft Excel into Outlook, but Outlook gives me a message that the Excel document has to have named ranges set up. How do you set up named ranges for an Excel worksheet to import it into Outlook?

Open the Excel document. Select the data you want to import. Choose Insert, Name, Define, and give the selected area a name. Save and close the document. You should now be ready to import the data into Outlook.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.