Outlook – Copying email address from to/cc/bcc field only copies name (address not in contacts)

microsoft-outlookmicrosoft-outlook-2007

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.

Best Answer

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 names...no addresses...when I paste in the body of the email.

Related Question