help exporting outlook contacts

why won't it put it in a usable CSV format?

[nquinn]

Here's the situation. There are 2 primary problems here.

I am trying to export some MS Outlook (not express)
contacts. We simply need these in a usable format ( CSV, tab delimited, whatever) so that we can paste it into FileMaker. Other options to help us just print out some labels would be fine as well.

The big 2 problems:

(1) The user has a 'contacts' folder and an 'other contacts' folder. Outlook only offers the 'contacts' folder to export

(2) In an experiement, we exported the normal 'contacts' folder. However, the data was totally misarranged. Some of the email addresses were improperly parsed ( '.com' was in the last name field, etc ). I tried tab delimited, comma delimited, and the excel format, all to no avail. I tried both opening them in excel, as well as creating a new file and using Data > Import ( csv )

Any ideas on how to get some usable data out of this POS?

[vkaryl]

Can you just copy the "other contacts" folder elesewhere (like windows\temp), and rename it "contacts"?

Oh - also you might try importing the Outlook stuff into OE FIRST, then exporting. I've found that OE is MAGNITUDES better at this sort of thing than is Outlook.

[anallawalla]

I tested this with Outlook 2003 and the export to .CSV is perfect.

Using Word for mail merge labels also works fine. Have done it for years.

[watercrazed]

It sound like the data in outlook is mis-formated for example if you have an email, and click on add to contacts, if the email does not have a name associated with the email address it will try to add the email address as a name, often assigning .com to the last name field or other wierdness.

[watercrazed]

As to the contacts and other contacts, why not create a new folder old contacts, move the contacts into old contacts, move other contacts into contacts export them move them back to other contacts and old contacts back into contacts.

[watercrazed]

BTW I am using Outlook 2000 with updates, works fine.

[Providence]

I am trying to export contact information on Outlook 2000 and the notes field at the bottom is creating a new record for every return value in every note field for every record.

As a result, I'm getting thousand more records than I should be.

Is there a way to keep a one-to-one relationship between all the fields in a record and the record as a whole.

I suppose someone must have written a program to do so.

Kind regards in advance!

John Michael