Copying cc email addresses to Excel - does not copy the <joe.bloggs@isp.com>

Status
Not open for further replies.

Awethentic

Member
Outlook version
Email Account
POP3
Dear All,

When trying to copy email addresses from the to/cc/bcc section at the top of an email, if the email is in the format (example only) -

Joe Bloggs <joe.bloggs@isp.com
then even if you copy the whole line as shown above as it appears in the to/cc/bcc section of the email (even if I take it from a "reply to all" email made from the original received email), then in Excel or in any other document that you paste to, including the "members" box of a distribution/contact group list, the result of the paste is -

Joe Bloggs

So, the <joe.bloggs@isp.com> section is NOT pasted.

However, if the email in the to/cc/bcc section of the email is in the format -

joe.bloggs@isp.com

without the pointy brackets (ie the sender may have put the address in manually in his to/cc/bcc box or has not associated a name with the email in the contact list), then the result of the paste is -

joe.bloggs@isp.com

without the name Joe Bloggs, which is understandable, as no name is associated with that email address.

So, my question is -

How can you copy an email address in the form of "Joe Bloggs <joe.bloggs@isp.com>" from the to/cc/bcc box in such a way that when you paste it to Excel or in the "members" box of a distribution/contact group list, then everything gets copied - ie if the email address in the to/cc/bcc box is Joe Bloggs <joe.bloggs@isp.com>, then BOTH the name and the email address are copied and not JUST the name, which seems a bit brain damaged to me for the software to behave in this way. If you can see it, you should be able to copy and paste it.

Many thanks.

All the best, cheers and enjoy.

Michael
 
Re: Copying cc email addresses to Excel - does not copy the <joe.bloggs@isp.co

I'll copy me reply from the other post -




In versions before Outlook 2010, when you copy the names from the address fields you'll only get the display name (which may be the name, the address or both). If you have a contact for the person, the name will resolve if you paste it into a new message or a Contact group (DL) but you can only use it within Outlook. For use in Excel or if you don't have a contact for the person, you need to get the addresses from the message header.




(Outlook 2010 will paste the name and address as .)






http://www.slipstick.com/tutorial/how-to-create-a-distribution-list-from-a-list-of-addresses/ shows how to get the addresses from the message header.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
H Copying email address(es) in body of email and pasting in To field Outlook VBA and Custom Forms 1
R VBA for copying sent email to current folder under a shared mailbox Outlook VBA and Custom Forms 17
Mary B Outlook 2013: Rule for copying new email to folder & marking that copy as read Using Outlook 1
M Outlook changes the "Modified" field when moving/copying a Contact. Using Outlook 0
P Copying ALL calendar entries from Calender in PST file to IMAP OST file? Using Outlook 1
E Copying the whole e-mail body into excel Outlook VBA and Custom Forms 0
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
T Copying Outlook Account Setup For Desktop App Using Outlook 5
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
Thiago Manzano Copying E-mails to a folder on HD Using Outlook 1
Diane Poremsky Mark Sent Items as Read After Copying with a Rule Using Outlook 0
crazyboy Copying BCM database from backed up mounted image to new drive BCM (Business Contact Manager) 2
oliv- Prevent copying shared contacts Outlook VBA and Custom Forms 5
Paul Butticaz Copying Contacts from SharePoint List (connected to Outlook) to another Conacts folder Using Outlook 1
K Outlook 2010 Not responding after IMAP folder deletion or copying. Using Outlook 2
S Calendar items are not being uploaded to outlook.com after copying Using Outlook.com accounts in Outlook 1
P open reminders missing after copying outlook pst file Using Outlook 2
L Copying Emails using drag and drop Using Outlook 2
O New to Outlook 2013, dealing with copying vs. moving sent items Using Outlook 0
S Recover messages that disappeared when copying to folder Using Outlook 1
S Copying multiple messages to folders and keeping date/time detail Using Outlook 1
D Copying POP3 folders from Inbox to IMAP Inbox in Outlook 2003 Using Outlook 0
M Copying setups for mutiple users Using Outlook 2
T Location and simple copying of emails and settings, OL 2010 and Win 7 64bit. Using Outlook 3
A Copying additional contact fields when chosing "Contact from the same company" Using Outlook 5
S Search Indexing (Copying Folders) Using Outlook 0
E Copying multiple folders to PST Outlook VBA and Custom Forms 2
B Copying data between atbs in a custom form Outlook VBA and Custom Forms 4
R copying a custom view from a public folder and distributing programatically Outlook VBA and Custom Forms 3
N error when copying outlook data "can not copy: the path too deep" Using Outlook 6
N Copying outlook macros between pcs Outlook VBA and Custom Forms 1
R Copying Data from Exchange to PST file Outlook VBA and Custom Forms 1
V Copying contents from one field to another field Outlook VBA and Custom Forms 6
M Outlook 365 adding standard message in body of template email Outlook VBA and Custom Forms 3
E Create Rule to Forward Email if Subject Begins With Using Outlook 2
V iCloud For Windows v15.x - Missing Email Features ? Using Outlook 4
M Thunderbird email client - I wonder Using Outlook 1
D Outlook Desktop App Email Software Using Outlook 0
P Email and calendar entry text now shifts right about 3 tabs worth of space Using Outlook 1
J Outlook macro to run before email is being send Outlook VBA and Custom Forms 0
T Outlook 2010 Creating a email 'Group' in OL 2010 Using Outlook 2
D Send email from Outlook Alias using Mac? Using Outlook 0
T How to set Default FONT for Email composing ? Using Outlook 0
H Finding text in open email Outlook VBA and Custom Forms 12
T Why do Outlook Desktop 2021 tasks from my wife's email show up in my task pane? Using Outlook 2
A Opening a link from an email automatically Outlook VBA and Custom Forms 0
D Outlook 2021 New email reminder Using Outlook.com accounts in Outlook 1
Rupert Dragwater How do I remove an email ending with @gmail.com Using Outlook 4
M A plug in (or method) to keep email message formatting after it expires Using Outlook 1
L VBA to Triage Incoming Email Outlook VBA and Custom Forms 0

Similar threads

Back
Top