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
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.
About the Author
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