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

in excel save as csv, in outlook - file/import export/from another program or
file/comma separated values (windows) ... etc

"Help with outlook" wrote:

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

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

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

InsertNameDefine

It is not there in 2007

Use the shortcut Ctrl F3(working in all Excel versions) to open the Name Dialog
and give your range a name




--

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


"jerz1964" wrote in message ...
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

I test it also in 2007 and I notice that you can only import
Excel 97-2003 files (You not see Excel 2007 in the list)

Strange

--

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


"Ron de Bruin" wrote in message ...
InsertNameDefine

It is not there in 2007

Use the shortcut Ctrl F3(working in all Excel versions) to open the Name Dialog
and give your range a name




--

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


"jerz1964" wrote in message ...
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

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

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

For the OP

See also
http://www.rondebruin.nl/0307commands.htm

Good night


--

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


"Ron de Bruin" wrote in message ...
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

Maybe saving as *.csv would be better?

Have you tried that in 2007 Ron?


Gord

On Mon, 19 Jan 2009 23:20:08 +0100, "Ron de Bruin"
wrote:

I test it also in 2007 and I notice that you can only import
Excel 97-2003 files (You not see Excel 2007 in the list)

Strange

Hi Gord

I check it with the Outlook pro's and
the new 2007 formats are not supported.

Maybe saving as *.csv would be better?

I think this will work OK Gord (no new format) but not test it.
Will test it this evening


--

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Maybe saving as *.csv would be better?

Have you tried that in 2007 Ron?


Gord

On Mon, 19 Jan 2009 23:20:08 +0100, "Ron de Bruin"
wrote:

I test it also in 2007 and I notice that you can only import
Excel 97-2003 files (You not see Excel 2007 in the list)

Strange

Hi Gord

I think this will work OK Gord (no new format) but not test it.
Will test it this evening

CSV is working OK in 2007
But in Outlook 2007 it is not possible to import Excel 2007 files.

Maybe I add a page about this Gord on my Mail page with a few screenshots.


--

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


"Ron de Bruin" wrote in message ...
Hi Gord

I check it with the Outlook pro's and
the new 2007 formats are not supported.

Maybe saving as *.csv would be better?

I think this will work OK Gord (no new format) but not test it.
Will test it this evening


--

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Maybe saving as *.csv would be better?

Have you tried that in 2007 Ron?


Gord

On Mon, 19 Jan 2009 23:20:08 +0100, "Ron de Bruin"
wrote:

I test it also in 2007 and I notice that you can only import
Excel 97-2003 files (You not see Excel 2007 in the list)

Strange

Good idea Ron

Thanks for the testing time and effort.


Gord

On Tue, 20 Jan 2009 22:41:13 +0100, "Ron de Bruin"
wrote:

Hi Gord

I think this will work OK Gord (no new format) but not test it.
Will test it this evening

CSV is working OK in 2007
But in Outlook 2007 it is not possible to import Excel 2007 files.

Maybe I add a page about this Gord on my Mail page with a few screenshots.

I send you a test webpage private Gord for review
I hope you have time to look at it

--

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Good idea Ron

Thanks for the testing time and effort.


Gord

On Tue, 20 Jan 2009 22:41:13 +0100, "Ron de Bruin"
wrote:

Hi Gord

I think this will work OK Gord (no new format) but not test it.
Will test it this evening

CSV is working OK in 2007
But in Outlook 2007 it is not possible to import Excel 2007 files.

Maybe I add a page about this Gord on my Mail page with a few screenshots.

Thanks Ron

I checked it over and give it the good housekeeping seal of approval.

Users will be able to follow the steps.

What section on your site will the page be linked to?


Gord


On Wed, 21 Jan 2009 23:10:51 +0100, "Ron de Bruin"
wrote:

I send you a test webpage private Gord for review
I hope you have time to look at it

Hi Gord

The link to the page is

Convert Excel data to Outlook Contacts
http://www.rondebruin.nl/mail/importcontacts.htm

And I add the link to my mail page in the "Other Tips" section
http://www.rondebruin.nl/sendmail.htm


Thanks for looking at it


--

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Thanks Ron

I checked it over and give it the good housekeeping seal of approval.

Users will be able to follow the steps.

What section on your site will the page be linked to?


Gord


On Wed, 21 Jan 2009 23:10:51 +0100, "Ron de Bruin"
wrote:

I send you a test webpage private Gord for review
I hope you have time to look at it