Problem importing data from Excel into Outlook 2007 Contacts

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.
 
G

Gordon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top