problem importing email addresses from excel to outlook

[rolbts]

I'm importing a list of contacts from excel to outlook. I have office
enterprise 2007. Only some of my contacts have email addresses. Those that
don't have email addresses have a "0" in the cell. When I import the data I
only get the "0" email addresses and get a blank field for those contacts
that have actual email addresses in my excel spreadsheet. What is the problem?

 

[Brian Tillman [MVP - Outlook]]

I'm importing a list of contacts from excel to outlook. I have office
enterprise 2007. Only some of my contacts have email addresses. Those that
don't have email addresses have a "0" in the cell. When I import the data I
only get the "0" email addresses and get a blank field for those contacts
that have actual email addresses in my excel spreadsheet. What is the
problem?

Is this an XLS file or a CXSV file? If the former, have you properly
specified the named range to include all of the data you're trying to import?
I'd also remove the zeros and use empty cells.

 

[Brian Tillman [MVP - Outlook]]

Is this an XLS file or a CXSV file?

Oops. That should be "CSV"

 

[rolbts]

It is an xls file that I saved as an excel 97-03 compatible file and have a
named range for the export.
I have since tried saving as a csv file and it worked but I would still like
to know why the xls file did not work.

 

[Brian Tillman [MVP - Outlook]]

It is an xls file that I saved as an excel 97-03 compatible file and have a
named range for the export.
I have since tried saving as a csv file and it worked but I would still like
to know why the xls file did not work.

Um, named ranges are for importing. I don't understand the reference to
"named range for the export".

 

[rolbts]

To import the excel data to Outlook it requires that you name a range in the
excel file. The named range is what becomes exported from excel and imported
into outlook.

 

[Brian Tillman [MVP - Outlook]]

To import the excel data to Outlook it requires that you name a range in the
excel file. The named range is what becomes exported from excel and imported
into outlook.

But you're not exporting from Excel.

 

[rolbts]

OK, I'm not exporting from excel, just importing to outlook. I still don't
understand why the email addresses did not transfer when everything else did.

 

[Brian Tillman [MVP - Outlook]]

OK, I'm not exporting from excel, just importing to outlook. I still don't
understand why the email addresses did not transfer when everything else
did.

In the majority of cases, the problem is that either that the data is outside
of the named range or that the mapping is incorrect.