Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: How do I name the range of data in Excel

    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?


  2. #2
    Join Date
    Oct 2003
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts