Import Excel to Outlook creates separate records for each field (c

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wizbard - 25 Oct 2005 18:56 GMT

When I try and import to Outlook 2003 from an Excel .xls contact data
spreadsheet, after I click "Finish" each cell of the spreadsheet is imported
into a separate Outlook record. I've tried mapping every way I can think of.
What am I doing wrong?

Reply to this Message

wizbard - 25 Oct 2005 19:20 GMT

Never mind. I imported successfully by adding a .csv step to the process.

> When I try and import to Outlook 2003 from an Excel .xls contact data
> spreadsheet, after I click "Finish" each cell of the spreadsheet is imported
> into a separate Outlook record. I've tried mapping every way I can think of.
> What am I doing wrong?

Reply to this Message

rachel - 13 Jan 2006 18:58 GMT

How did you "add a .csv step"? Someone else told me to do this, but i don't
know how!

> Never mind. I imported successfully by adding a .csv step to the process.
>
> > When I try and import to Outlook 2003 from an Excel .xls contact data
> > spreadsheet, after I click "Finish" each cell of the spreadsheet is imported
> > into a separate Outlook record. I've tried mapping every way I can think of.
> > What am I doing wrong?

Reply to this Message

wizbard - 13 Jan 2006 21:30 GMT

Hi Rachel,

I just meant that I saved the Excel file I wanted to import as a .csv file
(instead of .xls) and then imported the .csv into Outlook, after making sure
I had everything mapped correctly. Worked like a charm.

-wiz

> How did you "add a .csv step"? Someone else told me to do this, but i don't
> know how!
[quoted text clipped - 5 lines]
> > > into a separate Outlook record. I've tried mapping every way I can think of.
> > > What am I doing wrong?

Reply to this Message

Rate this thread: