Take the 2-minute tour ×

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 fred@work.com, fflintstone@home.com. –  Scott Aug 30 '12 at 20:01

2 Answers 2

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


share|improve this answer

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".

share|improve this answer

Your Answer


