problem importing email addresses from excel to outlook

  • Thread starter Thread starter rolbts
  • Start date Start date
R

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?
 
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?
Click to expand...

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.
 
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.
 
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.
Click to expand...

Um, named ranges are for importing. I don't understand the reference to
"named range for the export".
 
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.
 
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.
Click to expand...

But you're not exporting from Excel.
 
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.
 
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.
Click to expand...

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.
 
Back
Top