importing .csv to Contacts (2002)

[baltobernie]

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

 

[baltobernie]

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.