Copying email address from to/cc/bcc field only copies name (address not in contacts)
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.
microsoft-outlook microsoft-outlook-2007
asked May 15 '13 at 23:35
TurchTurch
156228
add a comment |
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.
microsoft-outlook microsoft-outlook-2007
asked May 15 '13 at 23:35
TurchTurch
156228
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
1
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17
add a comment |
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.
microsoft-outlook microsoft-outlook-2007
asked May 15 '13 at 23:35
TurchTurch
156228
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.
microsoft-outlook microsoft-outlook-2007
microsoft-outlook microsoft-outlook-2007
asked May 15 '13 at 23:35
TurchTurch
156228
asked May 15 '13 at 23:35
TurchTurch
156228
edited May 15 '13 at 23:41
Turch
asked May 15 '13 at 23:35
TurchTurch
156228
asked May 15 '13 at 23:35
TurchTurch
156228
asked May 15 '13 at 23:35
TurchTurch
156228
156228
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
1
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17
add a comment |
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
1
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17
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
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
1
1
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17
add a comment |
3 Answers
3
active
oldest
votes
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.
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
add a comment |
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.
answered Jan 19 '15 at 14:15
GuyGuy
1
add a comment |
Be on the message and click on three dots on the right(...). From drop down, click "view message source" ( option almost at the bottom). A text will appear.
This text will have sender email and then some longs strings. Scroll a page or two and you will see the email addresses this message was sent to.
Good luck...
RP
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f596080%2fcopying-email-address-from-to-cc-bcc-field-only-copies-name-address-not-in-cont%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
add a comment |
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.
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
add a comment |
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.
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
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.
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
answered Feb 10 '16 at 10:30
AymKdnAymKdn
1113
1113
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
add a comment |
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
This does not allow me to copy the text of the email address.
– Almo
Aug 26 '16 at 13:43
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
Wrong answer for the question, but it was what I was looking for, names not email address.
– JohnC
May 26 '17 at 19:06
add a comment |
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.
answered Jan 19 '15 at 14:15
GuyGuy
1
add a comment |
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.
answered Jan 19 '15 at 14:15
GuyGuy
1
add a comment |
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.
answered Jan 19 '15 at 14:15
GuyGuy
1
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.
answered Jan 19 '15 at 14:15
GuyGuy
1
answered Jan 19 '15 at 14:15
GuyGuy
1
answered Jan 19 '15 at 14:15
GuyGuy
1
answered Jan 19 '15 at 14:15
GuyGuy
1
1
add a comment |
add a comment |
Be on the message and click on three dots on the right(...). From drop down, click "view message source" ( option almost at the bottom). A text will appear.
This text will have sender email and then some longs strings. Scroll a page or two and you will see the email addresses this message was sent to.
Good luck...
RP
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
add a comment |
Be on the message and click on three dots on the right(...). From drop down, click "view message source" ( option almost at the bottom). A text will appear.
This text will have sender email and then some longs strings. Scroll a page or two and you will see the email addresses this message was sent to.
Good luck...
RP
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
add a comment |
Be on the message and click on three dots on the right(...). From drop down, click "view message source" ( option almost at the bottom). A text will appear.
This text will have sender email and then some longs strings. Scroll a page or two and you will see the email addresses this message was sent to.
Good luck...
RP
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
Be on the message and click on three dots on the right(...). From drop down, click "view message source" ( option almost at the bottom). A text will appear.
This text will have sender email and then some longs strings. Scroll a page or two and you will see the email addresses this message was sent to.
Good luck...
RP
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
answered Jan 22 at 23:51
Ranjan PathaniaRanjan Pathania
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f596080%2fcopying-email-address-from-to-cc-bcc-field-only-copies-name-address-not-in-cont%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
1
I am unable to duplicate the issue you are seeing.
– CharlieRB
May 16 '13 at 13:17