General Betting
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
sort by:
Show
per page
Replies: 4
|
By:
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.
|
|
By:
You are welcome, no worries.
dont mention it. |
|
By:
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
|
|
By:
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. |