rik1471

I have a list of email addresses for a mailout for a club I promote for. There are about 600 addresses, all in a word document each one seperated by a comma.

What is the best way to get each address as a record in a database?

I have already created the database, it's just the transferring i'm having trouble with.

Thanks in advance.

Rik.

rik1471

Is there a way of finding a replacing a comma with a carriage return in Word?

Then I could copy it into a text document and save it as a CSV (comma seperated value) file.

Then I could convert it to an Excel spreadsheet, and finally import it into Access.

Phew!

MartinM

Ctrl-H (find and replace)
Find what: ,
Replace with: Click More button
Click Special Button
Select Manual Line Break
Click Replace All

...this is Word 2000 - but u can do it in a similar way with previous versions

rik1471

Cheers.