I am trying to import data from Excel to Outlook and I get a message that says I first have to name the range of data in Excel. I get this message when I click on Excel as the data source.

Can anyone help me with this?

Thanks,

Suppose your data is in Column A, select all of the data, then go to Insert > Name > Define. At the bottom of the window in the "Refers To" box, it should have the references, i.e. $A$1:$A25. At the top of the dialog box, type in a name (no spaces), click "Add." Then close the dialog box.