Problem importing data from Excel into Outlook 2007 Contacts

  • Thread starter Thread starter Sammy E
  • Start date Start date
S

Sammy E

I have an excel spreadsheet (created in Excel 2007, but saved as a 1997-2003
file) containingcolumns for Company Name, Contact Name, Email Address and URL
- each row is a separate record.
I want to import these records into Outlook 2007, mapping the Company Name
to 'Company' in Outlook Contacts; Contact Name to 'Name'; Email Adress to
'Email' and URL to 'Web Page', keeping all fields for each line in excel in a
single contact record.
My Excel spredsheet contains a named ranges for each column, but when I try
to import the details using the Import & Export Wizard in Outlook, it mapa
each named range into a different contact record - ie I get 4 records, each
containing either the Company Name, or the Contact Name, or the Email address
etc, rather than just one including all of the information.
 
Sammy E said:
I have an excel spreadsheet (created in Excel 2007, but saved as a
1997-2003
file) containingcolumns for Company Name, Contact Name, Email Address and
URL
- each row is a separate record.
I want to import these records into Outlook 2007, mapping the Company Name
to 'Company' in Outlook Contacts; Contact Name to 'Name'; Email Adress to
'Email' and URL to 'Web Page', keeping all fields for each line in excel
in a
single contact record.
My Excel spredsheet contains a named ranges for each column, but when I
try
to import the details using the Import & Export Wizard in Outlook, it mapa
each named range into a different contact record - ie I get 4 records,
each
containing either the Company Name, or the Contact Name, or the Email
address
etc, rather than just one including all of the information.


Remove the named range for each column and give the whole range of data one
name. See if that helps.
 
Back
Top