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 <email@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.