Importing contacts from Excel to Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import an Excel spreadsheet into Outlook contacts. Only the Last or first names import, the other fields are blank. I have read previous posts on the subject and done the following

In Excel, I have three ranges I want to import, First, Last and Email. I have named the ranges First, Last and Email. I have put First, Last and Email on Row 1 in the spreadsheet. In excel, I have highlighted the appropriate ranges and then clidked "insert", "name", "define" and typed in First, Last and Email. I have saved the file as *.xls and as *.csv. (It adds .xls to the end of the .csv file name.) In Outlook I "import" an excel file, and map the fields. It shows the "importing email" box, "importing First" box and then the "importing Last" box.

If I search the contacts for a last name, a record with that name is found but there is no last name or email address. If I search for a first name, a record is found with that first name, but no last name or email addres is shown. If I search for an email address, no record is found

I have XP Pro, Outlook 2002 SP3 and Excel 2000 (9.0.6926 SP3

Please help

Thanks
 
Create one range that encompasses all three columns of Excel data, then
import that range.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Bill said:
I am trying to import an Excel spreadsheet into Outlook contacts. Only
Click to expand...
the Last or first names import, the other fields are blank. I have read
previous posts on the subject and done the following:
In Excel, I have three ranges I want to import, First, Last and Email. I
Click to expand...
have named the ranges First, Last and Email. I have put First, Last and
Email on Row 1 in the spreadsheet. In excel, I have highlighted the
appropriate ranges and then clidked "insert", "name", "define" and typed in
First, Last and Email. I have saved the file as *.xls and as *.csv. (It
adds .xls to the end of the .csv file name.) In Outlook I "import" an excel
file, and map the fields. It shows the "importing email" box, "importing
First" box and then the "importing Last" box.
If I search the contacts for a last name, a record with that name is found
Click to expand...
but there is no last name or email address. If I search for a first name, a
record is found with that first name, but no last name or email addres is
shown. If I search for an email address, no record is found.
 
Sue

Thank you very much for your response. Apparently, however, I need more help

After reading your response, I put the three columns of data that I want to import next to each other. I then named the three columns WHOLE using the INSERT, DEFINE function. When I highlight that range, WHOLE does appear in the box above the spreadsheet on the left side. I then saved and closed the spreadsheet. When I went into Outlook's IMPORT function and got to the box that says IMPORT A FILE and THE FOLLOWING ACTIONS WILL BE PERFOMED, importing WHOLE is not listed as an option. It still lists the range names for each column, but not for WHOLE

Thanks again for your help

Bill Murph

PS My original question is pasted elow

Create one range that encompasses all three columns of Excel data, the
import that range

--
Sue Mosher, Outlook MV
Author o
Microsoft Outlook Programming - Jumpstart fo
Administrators, Power Users, and Developer
http://www.outlookcode.com/jumpstart.asp

Bill said:
I am trying to import an Excel spreadsheet into Outlook contacts. Onl
Click to expand...
the Last or first names import, the other fields are blank. I have rea
previous posts on the subject and done the followinghave named the ranges First, Last and Email. I have put First, Last an
Email on Row 1 in the spreadsheet. In excel, I have highlighted th
appropriate ranges and then clidked "insert", "name", "define" and typed i
First, Last and Email. I have saved the file as *.xls and as *.csv. (I
adds .xls to the end of the .csv file name.) In Outlook I "import" an exce
file, and map the fields. It shows the "importing email" box, "importin
First" box and then the "importing Last" boxbut there is no last name or email address. If I search for a first name,
record is found with that first name, but no last name or email addres i
shown. If I search for an email address, no record is found
 
I'm afraid I can't explain why Outlook wouldn't recognize a named range. I'd
open the file and double-check it.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Bill said:
Sue,

Thank you very much for your response. Apparently, however, I need more help.

After reading your response, I put the three columns of data that I want
Click to expand...
to import next to each other. I then named the three columns WHOLE using
the INSERT, DEFINE function. When I highlight that range, WHOLE does appear
in the box above the spreadsheet on the left side. I then saved and closed
the spreadsheet. When I went into Outlook's IMPORT function and got to the
box that says IMPORT A FILE and THE FOLLOWING ACTIONS WILL BE PERFOMED,
importing WHOLE is not listed as an option. It still lists the range names
for each column, but not for WHOLE.
 
Sue

Thanks. On the suggestion from a previous post, I was working with a spreadsheet saved as a csv file. Once I saved as a xls file, Outlook recognized the WHOLE range

Bil
 
Back
Top