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

Status
Not open for further replies.

Awethentic

Member
Outlook version
Outlook 2007
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
 

larry

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
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
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
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
D Wrong email address in Outlook 2003 "From" tab in new outgoing emails Using Outlook 1
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
F Forward incoming email with 4 embedded images in the body without original sender Outlook VBA and Custom Forms 22
W Macro to Filter Based on Latest Email Outlook VBA and Custom Forms 6
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
C Outlook 2007 Removing then adding account restores junk email processing Using Outlook 0
G Place jpg in body of email Outlook VBA and Custom Forms 1
F Wishlist Outlook suddenly began synchronizing deleted items every time I delete a single email. Using Outlook 2
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
HarvMan Toggle between calendar and email in Outlook 365 Using Outlook 12
F Email being marked as Spam by Gmail and not being visible in Outlook Using Outlook 5
G Email time stamp Using Outlook 2
G Schedule recurring email and attachments display Outlook VBA and Custom Forms 3
G Save and Rename Outlook Email Attachments Outlook VBA and Custom Forms 0
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
M How to setup outlook after importing old account information - Entering email account info creates with "(1)" after the account! Using Outlook 1
K Multiple Rules on Single Email Using Outlook 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
e_a_g_l_e_p_i Outlook 2010 How to set default email address for website links Using Outlook 3
O Same email address, same person, names in so many ways Using Outlook 4

Similar threads

Top