| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert a excel database to outlook contacts
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to convert a excel database to outlook contacts
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Excel database into Outlook Contacts says "No Named Rang | Excel Discussion (Misc queries) | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| export from 07 excel to outlook contacts | Excel Worksheet Functions | |||
| Selected Outlook contacts to excel | Excel Discussion (Misc queries) | |||
| How do I share excel contacts with outlook? | Excel Discussion (Misc queries) | |||
Hybrid Mode
