View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?