Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert Excel file into an Outlook file
I am trying to import an excel file into Outlook. When I go through the
import function it is putting each column into one contact but not all of that contacts information. So, I will have a list of contacts with just the company name. Is there something else I have to do to the Excel file before importing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert Excel file into an Outlook file
I've never tried doing it (i.e. I'm guessing !! <bg), but you might
like to try saving the Excel file as a .csv file, and then import that into Outlook. Hope this helps. Pete On Oct 16, 11:36 pm, Coverton wrote: I am trying to import an excel file into Outlook. When I go through the import function it is putting each column into one contact but not all of that contacts information. So, I will have a list of contacts with just the company name. Is there something else I have to do to the Excel file before importing? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert Excel file into an Outlook file
Assuming you have separate columns for each field and a Title for each column
you must "Map" the fields into Outlook by dragging the fields from the Excel file to the appropriate fields in Outlook You will be given this option after you have gone through the steps and get to the point where you select to Import to Contacts. See button "Map Custom Fields" Drag headers to Outlook Contacts fields. Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 15:36:02 -0700, Coverton wrote: I am trying to import an excel file into Outlook. When I go through the import function it is putting each column into one contact but not all of that contacts information. So, I will have a list of contacts with just the company name. Is there something else I have to do to the Excel file before importing? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert Excel file into an Outlook file
Excel file is one of the file type options Pete and works fine as long as each
field is in its own column with a title. I do it quite often to import new distribution lists to Contacts. Gord On Tue, 16 Oct 2007 15:47:23 -0700, Pete_UK wrote: I've never tried doing it (i.e. I'm guessing !! <bg), but you might like to try saving the Excel file as a .csv file, and then import that into Outlook. Hope this helps. Pete On Oct 16, 11:36 pm, Coverton wrote: I am trying to import an excel file into Outlook. When I go through the import function it is putting each column into one contact but not all of that contacts information. So, I will have a list of contacts with just the company name. Is there something else I have to do to the Excel file before importing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2002 -how can you convert a file to a pdf read only file? | Excel Discussion (Misc queries) | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
How do I increase file limitations to convert a file to Excel? | Excel Discussion (Misc queries) |