Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

Here is a solution found on another forum:

1) In the email window, click the To: button. The Select Names Global Address List dialog box opens.

2) Add all of the people you want to any of the fields.

3) Before clicking OK, copy the names from the desired field.

By copying the names from the To: field in the Select Names window, I am able to get just the addresses...when I paste in the body of the email.

share|improve this answer

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .