General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
hi guys I run a small club with about 6000 members I do newsletters for them once a fortnight with all our upcoming events etc. I have a excel file with all the email addresses in, is there a way of sorting them by email address so all the aol. ** yahoo etc are all together in groups without me doing this manually, part of the problems are that the free accounts get bounced and it then makes sending all the emails take too long, so if I can remove the ones that bounce to there own file It wouldn't take as long to do each newsletter. thanks in advance
Show More
copy the email addresses so you have a 2nd copy in column b. Then use Text To Columns to split everything after the @ to a new column. Then you can sort by this column in ascending order.
sorry morrigan I did say thanks in advance but I have only just read the reply, could you please tell me in more detail, I am a bit useless with excel.it is 2007 by the way
copy the email addresses so you have a 2nd copy in column b.
== straight forward enough
Then use Text To Columns to split everything after the @ to a new column.
== hightlight the column, go DATA / TEXT TO COLUMNS, choose delimited, put a @ in other and tick it.
Then you can sort by this column in ascending order.
== select the whole lot and sort by the data in the email address domain column.
== straight forward enough
Then use Text To Columns to split everything after the @ to a new column.
== hightlight the column, go DATA / TEXT TO COLUMNS, choose delimited, put a @ in other and tick it.
Then you can sort by this column in ascending order.
== select the whole lot and sort by the data in the email address domain column.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539