importing .csv to Contacts (2002)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

baltobernie - 26 Sep 2006 14:37 GMT

I get website inquiries forwarded to me in .csv format (Excel 2002).

The same data are always in the same cells, i.e. "city" information is
always in H2, "phone number" is always in L2, etc.

I am unsuccessful in importing this data into Contacts - Outlook 2002.
First I tried importing as "comma separated - Windows" file type, but the
.csv file did not appear in Browse.

So then I saved the data as Excel, and tried importing as "Microsoft Excel",
and the (reformatted) file appeared in Browse. But when I clicked Next, the
error message was "Use Excel to name the range of data".

Can I automate the creation of a Contact with this .csv-formatted data?

Bernie

Reply to this Message

baltobernie - 26 Sep 2006 15:58 GMT

Sorry, guys, it worked when I tried it one more time. Maybe I was trying to
import "tab delimited", but "comma delimited - Windows" definitely works
with .csv files. I was able to customize the fields to get info in the
proper location. It is a bit lengthly, maybe a macro would help.

>I get website inquiries forwarded to me in .csv format (Excel 2002).
>
[quoted text clipped - 12 lines]
>
> Bernie

Reply to this Message