Problem importing contacts to adress book

mrplow said:

Are the details separated by commas? Are the in the sequence required to match address book?

Are you getting particular error messages?

Click to expand...

hello1000 said:

this is the message and no, they are not separated by commas but listed under one another
each on a new

Click to expand...

mrplow said:

Well there's your problem right there. Renaming a file .csv does not change it's format.

Your data needs to be delimited by commas

E.g.
John,smith,123456,green drive,Manchester

If you add a dummy contact into mail and export it as csv you'll be able to take a look and match the format

Click to expand...

mrplow said:

I'm not sure there's too much more I can add.

In textedit you need to put each contacts information on a single line, separating each item of data with a comma. As per my example above.

The only other solution is to return to the source of your contact information and see if you can export it in a more appropriate format. Where did this current text file of data come from?

Click to expand...

mrplow said:

'Email list builder' ?

Got a link?

Click to expand...

vansmith said:

Unfortunately, as mrplow has noted, a simple list of email addresses won't work. The email addresses have to be in a specific format (csv or comma separated values) so you'll need to use another tool to do the job if you're not interested in doing it manually.

Click to expand...

mrplow said:

I think we've covered this in your other threads.

Without context - to answer the question? "how can I convert textedit files to cvs files" & "Is there a program that can help me?"
The answer is that any text editor with search and replace functions can insert commas into text given a particular set of rules. Spreadsheet functions are also useful for this kind of manipulation.

However, given the context of your other thread. What you have is a list of email addresses harvested from a web site (whether these recipients will be receiving solicited or unsolicited emails from you is unclear from your posts).
You are trying to import these into a mail client. But address books in mail clients have rules as to what constitutes a contact. In this case you need at least a name and an email address.
Also to import into the address book you need to know the order of the fields.
e.g. if it's expecting fields in sequence: First name, surname, email address you will need to supply comma seperated data in the same format. I.e. John, Smith, [email protected]
In some cases you can omit data (depending on the clients import rules). So you may be able to have john,,[email protected] - where having no data in the second field 'skips' the surname column.

Click to expand...

mrplow said:

Again, vCard is a particular format. So long as you convert/transform your data to match the vCard format that will work. In the same way as if you convert/transform you're data to match the csv format will work.
NB: working with csv is easier.

From the tool you're using, a web page email harvester, I'm going to guess and say these aren't personal contacts but some kind of bulk mailing list you're trying to put together. The company that supplied your harvester application sell various tools for creating such mailing lists. Perhaps contact the and ask you to proceed now you have output from their tool. I can see that as your only way forward as you don't seem to want to edit the data yourself

Click to expand...

mrplow said:

I think we've covered this in your other threads.

Without context - to answer the question? "how can I convert textedit files to cvs files" & "Is there a program that can help me?"
The answer is that any text editor with search and replace functions can insert commas into text given a particular set of rules. Spreadsheet functions are also useful for this kind of manipulation.

However, given the context of your other thread. What you have is a list of email addresses harvested from a web site (whether these recipients will be receiving solicited or unsolicited emails from you is unclear from your posts).
You are trying to import these into a mail client. But address books in mail clients have rules as to what constitutes a contact. In this case you need at least a name and an email address.
Also to import into the address book you need to know the order of the fields.
e.g. if it's expecting fields in sequence: First name, surname, email address you will need to supply comma seperated data in the same format. I.e. John, Smith, [email protected]
In some cases you can omit data (depending on the clients import rules). So you may be able to have john,,[email protected] - where having no data in the second field 'skips' the surname column.

Click to expand...