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

A salesperson at work asked me to help her copy email addresses from an Outlook bcc field. She sends out emails to various subgroups of her clients, in groups of several hundred. She wants to save the email addresses in Excel.

Edit: to be clear, the workflow she wants is "type in a bunch of emails into outlook, then copy them, then paste them to Excel either before or after the emails are sent"

She will start typing an email and Outlook autocompletes it to the form John Doe <>

When copying, Outlook only copies the name portion. In Outlook 2010, doing the same thing copies the entire address including the email in brackets.

The address isn't in her contacts (contacts get displayed as just John Doe). One solution I've seen is basically "create a contact", but that wouldn't work since she'd have to do it to all however many hundreds of her clients.

The solution suggested here doesn't work, as the emails are bcc'd and thus wouldn't show up in the email headers.

share|improve this question
Just a thought (I cannot confirm), but is it possible to select the text (name+email), then left-click and drag into the body? – Karan May 16 '13 at 1:41
I am unable to duplicate the issue you are seeing. – CharlieRB May 16 '13 at 13:17

Instead of copying/pasting the names difrectly from the "to" field in the email, go in the "Address book", paste the names in the "to" field, and when you will copy the names, they won't have their email addresses attached.

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.