How to export a distribution list to Excel

Microsoft Outlook 2003 (full product)
April 28, 2010 at 13:54:36
Specs: Windows XP
I need to find out how to export ONLY the contact names and email addresses from a specific outlook distribution list into excel.

Is there a way to do this WITHOUT exporting all of the contacts?

Any help is appreciated!

See More: How to export a distribution list to Excel

Report •

April 28, 2010 at 15:52:40
I don't know if there is an Outlook-specific process to do this but here is what just worked for me:

1 - Open the Distribution List
2 - Print it to a PDF (You can download free PDF creators from various websites - CutePDF & PDFCamp are just 2 examples. They install as "printers" on your system. When you "print" to them, they create a PDF file.)
3 - Copy all of the text from the PDF and paste it into Excel.
4 - In my case, it put both the names and the email addresses in
Column A.
5 - Use Data...Text to Columns...Delimited...Space to leave the names in Column A and move the email addresses to Column B.

Hope that helps.

Report •

April 28, 2010 at 16:03:44
Thanks for the reply. It will probably make it faster as I was about to resort to doing it manually anyway since the list is only about 100 contacts.

Thanks again!

Report •

Related Solutions

Ask Question