Outlook: Setting up Excel Named Ranges to Import into Outlook

Learn how to set up named ranges for an Excel worksheet to import it into Outlook.

Sue Mosher

July 30, 2002

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like