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.

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 <jdoe@example.com>

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

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.