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
M Full Guide +1760-284-5760 How to Access Your RR.net Email Outlook VBA and Custom Forms 0
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 5
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
Y QQ on Scheduled Delivery of an Email Using Outlook 0
T Replace Text in Email Subject Outlook VBA and Custom Forms 3
Rupert Dragwater Cannot reestablish gmail (email address) account in Outlook 365 Using Outlook 11
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

Similar threads

Back
Top