Could someone tell me how I sort the email addresses I have put in the BCC field in alphabetical order? I have sent an e-mail to a large number of people that I have exported from a database. I need to put these in alphabetical order so that I can find individual people and check there is no duplication. I can't see this option anywhere. Many thanks.
You really shouldn't do it by hand, especially because you'd need tool for sorting anyway. So why not go a step further and use a simple script in some dynamic language to do the job?
Of course this will clean-up any comma-separated list from duplicates, not just email addresses. Here's also a copy of this script packed in one line, for preservation and for use as bookmarklet content if you prefix it with
There is a great tutorial on how to sort with Excel
First, copy the entire data, and paste into a new workbook in excel.
Select the cell, and select: Data to Cells option, and select ',' as the seperator.
The tutorial is: http://www.contextures.com/xlSort01.html