I have a mailing list that I want to transfer but when I copy and paste I get the names and not the email addresses

Posted on 2008-10-13
Medium Priority
Last Modified: 2012-05-05
In outlook I have a list of people that I send a newsletter. It has grown a lot.

I want to transfer this email list to word and organize it, but I want to copy and paste the email addresses not the names of the people associated with the email addresses.

An example:
In outlook I see
TO: 'John, Doe' <jDoe@harvard.edu>; 'Alex, Antoli' <alex.Antoli@google.com>

when i copy and paste from the above list then i get
John Doe and Alex Antoli
but what I want is
jDoe@harvard.edu and alex.antoli@google.com

is this possible?

Question by:alexmac05
  • 3
  • 2
LVL 13

Expert Comment

ID: 22702705
Your best bet is to create a distibution list with the addresses in, then on the distribution list window file --> save as and choose the text only (*.txt) type.

this will produce a txt file with the name and email address.

Author Comment

ID: 22702759
That doesn't work to deal with the list I already have...

Is there no way to do it other then to retype all of these addresses?
LVL 13

Accepted Solution

Brum07 earned 2000 total points
ID: 22702849
LVL 13

Expert Comment

ID: 22702862
You can export to a number of different files including CSV for import into Excel

Author Closing Comment

ID: 31406220
awsome! THnaks

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A few solutions to a problem some of us have been having when trying to add Hostgator email accounts to Outlook 2016 (will probably work with Outlook 2013 as well).
Often, the users face difficulty in accessing Outlook 2016 PST files on Windows 10 computer. One of the reasons behind it is the improper functioning of MS Outlook when the user tries to open it. MS Outlook suddenly stops working, or it will not op…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question