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.