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

Status
Not open for further replies.
A

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.
< Outllook 2007 stops connecting with Exchange after latest MS Updates | daily email count in Outlook >
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
J column with actual email address in Outlook Classic Using Outlook 2
S Not receving all email since converting from Outlook 2007 to Outlook Classic Using Outlook 3
Rupert Dragwater Outlook 365 taking too long to synchronize each time email is being checked Using Outlook 17
D Request help with a macro for forwarding email Outlook VBA and Custom Forms 7
e_a_g_l_e_p_i Need help updating email in Outlook 2021 Using Outlook 10
N Why does Outlook keeping adding to the email address I have in my notes portion of a contact? Using Outlook 2
P SPAM message about Comcast email migration to Yahoo Using Outlook 1
P anything new on the supposed shutdown of comcast.net email? Using Outlook 6
S Is there an add-in to PDF entire folders of email with Microsoft 365? Using Outlook 4
W frustrating trying to change email password Using Outlook 5
R File not found when sending email with attached pdf file Using Outlook 2
U Trouble sending large files to a email group but can to the individuals in that group Using Outlook 8
P Xfinity/Comcast email service stopping sometime in 2025 - warning Using Outlook 6
O Two identical email accounts in Offline Global Address List Using Outlook 2
H Spam email in Gmail not visible in Outlook Using Outlook 3
J Renegade spam URL line displayed in old local Outlook 365 email title Using Outlook 3
L Hide Selected Email Address from Address Book Using Outlook 5

Similar threads

Back
Top