I have a list of emails that I need to send a newsletter to. The list I have has a space in between each email address. The program I will be using to send the email needs to have the emails listed with one email per line like this: “johndoe@hotmail.com janedoe@yahoo.com,,, ” Andi I need it to list then one per line. The file i am using is a text file. Notepad has no way to mass edit the list the way I need to. Anybody have any suggestions on how I can quickly edit this .txt file?
I tried doing the excell method, but it limits it to about 250 lines. Is there a way to extend this? Not very good with excell.
Doing it by hand is out of the question, as there about 75000 members
July 7th, 2009 at 5:25 pm
In my experience, you spend longer trying to find an automated way of doing something than you would just doing it manually.
July 9th, 2009 at 11:06 pm
Its easy … open MS Excel…..now open this file thru it (dont open it directly …use the open command in excel menu.
If u cant see the file select the option show all files. Now as soon as u open the file u get text import wizard. Click the delimited option and click next. Now select space option under delimiters. then press finish. Now u can see that all the email addresses are in separate columns. Now copy the entire row and go to a cell of which column does not have any data now open use the paste special function and click Transpose option. ur entire row will be pasted vertically delete all the data except ur new column….cut the data and paste on A column at A1. now save the file it will say all formatting will be lost click yes ok……..ur text file has been updated.
July 10th, 2009 at 7:54 am
Notepad is not going to help you, you need more useful text editors. You could try downloading a fancier text editor like Textpad.
The daring/technically advanced could use something like sed.
But the easiest way may be just to do it by hand, and get your fingers into a rhythm. It may help to know that Ctrl+Right will advance to the next whole word. So… Ctrl+Right, Enter, Ctrl-Right, Enter, Ctrl-Right….. etc.