Yes, Outlook requires the range to be named. To do so:
a) Select the range, including all the column labels and all the data
b) Go to the Formulas tab and click ‘Define Name’
c) Verify the ‘Refers to” box lists the correct range
d) Type the desired name… “data”, for example, in the Name textbox. No space characters are allowed. Then click OK to close the ‘New Name’ dialog box
Outlook 2007 also required that the Excel file be a version 97-2003, so you will need to save it as one.
|