Mailing List Manager Freeware
How do I arrange two or more email address lists alphabetically and removing duplicates?
I have several email address lists. Some are arranged vertically and some are in lines.
I need to first merge and arrange the lists alphabetically with duplicates removed. Each address should have a coma after the address.
I have tried various freewares like Npust List manager, List Man Pro,Free Mailing List Merger etc. but they do not give what I need. The Npust generates a list that is neithr in word nor in text file so it cannot be read.
Anyone who precisely understands above and has a solution freeware or any other way using MS WORD or something, kindly advise.
Thanks.
You can’t do it with Word unless you want to code a macro for it, but you can easily do it with Excel. Just paste the email lists in a single Excel worksheet.
First to filter unique records, select your column of emails, go to Data->Filter-Advanced Filter. Select Copy to another location, and for the Copy To range, select an empty column, tick Unique records only, then Ok.
To sort alphanumerically, select this new column, then go to Data->Sort and follow the prompts.
You can then paste this list into Word if you want.