Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
WHat program, what operating system? Needs more info. – Xavierjazz Aug 30 '12 at 15:30
Possibly sort the email addresses alphabetically when exporting from the database. Not sure how the database and Outlook are connected. Any clarification you can provide would be helpful. – dangowans Aug 30 '12 at 15:37
Do you even need to do this? If you send an email bcc: fred, barney, fred, does fred get two copies? I expect that Outlook will de-dupe the list. ... Unless you're talking about de-duping, – Scott Aug 30 '12 at 20:01

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?

Hmm, thinking about that, easiest for you to use would be JavaScript, since its built-in in pretty much every browser and does not require any additional installations, so I just wrote a quick script to clean-up duplicate entries in comma-separated string and uploaded it to jsFiddle <---- click this shiny link, copy/paste entire Bcc: line into "Comma-separated address list" prompt and then copy/paste results from "Copy/paste unique results".

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 javascript:.

var cs = prompt("Comma-separated list:"); var separated = cs.split(/\s*,\s*/); var uniq = {}; var uniq_list = []; for (var idx = 0; idx < separated.length; idx++) { if (!uniq[separated[idx]]){ uniq[separated[idx]] = 1; uniq_list.push(separated[idx]) }; }; prompt("Copy/paste unique results:", uniq_list.join(', '))
share|improve this answer

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:


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.