Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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
add comment

2 Answers

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

HTH

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.