InsertNameFormulasDefined Names.

On the Formulas Tab
In the Defined Names group click on Define name

But Ctrl F3 is easier and working in all versions


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
InsertNameDefine is from Excel 2003

For Excel 2007..............

First select the range of data including the headings

InsertNameFormulasDefined Names.


Gord

On Mon, 19 Jan 2009 13:50:04 -0800, jerz1964
wrote:

Ron,
you responded:Select the range of data including the headings.
InsertNameDefine. Give it a name like MyContacts
Save the workbook. I am not understanding InsertNameDefine??? I feel I
am close but every time I go to outlook and try to import the contacts from
the excel spread sheet it says I need to define the fields. the top row of
my spread sheet is labels from outlook 2007 contact so I am not sure what I
am missing. Any feedback would be appreciated.



"Ron de Bruin" wrote:

Gord Dibben posted this:

Select the range of data including the headings.
InsertNameDefine. Give it a name like MyContacts
Save the workbook.

Open Outlook and FileImport/ExportImport from another programMS Excel

Browse to the Excel file and select it then follow your nose through selecting
the Contacts folder and mapping the fields.

Alternative to naming the range is to save the Excel workbook as a *.CSV file
and import that into Outlook.


Gord Dibben MS Excel MVP




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Help with outlook" <Help with wrote in message
...
I have a database of 450 names with phone numbers and addresses in a excel
workbook. I would like to import this into my contacts in either outlook 2007
or windows live