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.