Site Reference Forums

Firstly, get them out of word - copy them into a plain text document

if the emails are inline, then you'll want to replace whatever's between them with a carriage return or line feed carriage return, so you have a list of emils in plain text

then save your file as .csv

then your database should be able to read it.

so

blah@email.com, blah2@email.com, blah3@email.com, blah4@email.com

becomes

blah@email.com
blah2@email.com
blah3@email.com
blah4@email.com

if you use something like textpad you can find and replace using special characters as well as regular expressions

eg find

,
[comma space]

replace with
\n (or \r\n)
[carriage return (or line feed carriage return)]

you can download a fully working demo of textpad at textpad.com

if you need to put numbers next to them (eg incremental id) - copy your list into excel (col B) and use the auto increment function to put in the numbers in col A, then save as CSV