How to export Outlook Distribution List to #creating #a #distribution #list #in #outlook, #software #apps
How to export Outlook Distribution List to .csv file format
42 thoughts on How to export Outlook Distribution List to .csv file format
i WOULD LIKE TO EXPORT MORE THAN ONE DISTRUBUTION CONTACT AT A TIME. IS THIS POSSIBLE, IS SO HOW i HAVE 600 TO DO
Does not work!
All I get in the final Excel file (CSV) is the name of the Distribution list rather than each contact/email separately
Dude that is a ugly solution.
Here is a better one that will require a little bit of work but neater. I m using Outlook 2003
On the Menu Bar, Go to File New, click on Folder.
In the Create New Folder window,
type in a name (I use Export but can be anything)
Select Contact Items in Folder Contains drop down list.
Under Select Where to Place Folder I just choose Personal Folders.
Unfortunately you can t export the distribution list directly. But what you can do is copy all the contacts from your main Contacts folder into the Export folder.
So in the top left of the outlook window you should see under My Contacts Contacts, Search Results and the newly created Export.
Click on contacts, under current view I would choose Phone List or by Category (I created categories for my distribution lists now, it makes the next part easier.)
Holding CTRL down click on each contact you want to export.
When you are done, Choose Copy from the Edit menu bar.
Click on the Export contact folder and Paste.
Then export as normal
File Import and Export
Select Export to a File, Next
Select Comma Separated Values (windows), Next
Select folder to export from Export, Next
name the file, map the fields and you re done.
thanks so much for sharing, yes, your method above works well too.
Monique replied on December 15th, 2009 :
How can this be done in 2007?
Bill replied on January 10th, 2011 :
Leah replied on June 24th, 2011 :
I followed your instructions and worked perfectly. Just one question how do I keep the last name and first name in two separate columns. Right now I have 2 columns: 1 with firstname lastname. and 1 with email.
This worked well. It s not ugly.
Thank you! I use 2007 and it worked wonderfully.
I m using Outlook 2003. I am unable to find any way to list my various Distribution Lists of which I have 7. They are outdated, I want to delete the DLs. In the Outlook folder list, all I have is Contacts without any + no way to see the DL names. If I click to create a new email, I can then click in To: CC: BC: then click on the Contact box (upper right corner), see a DL name then select it then click in one of the choices in which to paste the list. I then copy the list past it into Word (as a table) or Excel. However, I see NO way to DELETE a DL that I want to Delete.
Any suggestions? I do NOT want to Delete my list of Contacts just the DLs (all of them).
Milton replied on March 3rd, 2011 :
Thank you. Super helpful!
You have no idea how many hours you have just saved me, or maybe you do. Thank You!
I found this worked perfectly first time THANK YOU!
I have many distribution lists with about 50 contacts in each. Since DL can not be used for mail merge, how can i take the contacts that are already in a distribution list and catagorize them by color to use in a mail merge to get around this problem without “doing them over?”
I have a group that I created in my distribution list along with all my contacts. I have about 35 in this group and I m trying to send it (export it?) to another person. Any ideas on how to do this?
Well, I have a weird problem here.
What I am trying to do, is to get the First Name and the Email IDs of all the people in a Distribution List. I am going to use Mail Merge to send emails to each of them in the distribution list, seperately. I would need (at least) their first names and email IDs to do so
Can anyone throw some light on this? How would I get a list of all the email IDs and their respective first names (preferably in an excel workbook), so that I can use Mail Merge to send them emails later?
Thanks in advance!
Note: I do not want to add each of them to my outlook address book, as I am going to send emails to many and the distribution list would change each time I do so