How to export distribution list to excel

G

Guest

Would like to know how to export distribution list to excel, so that it could
be shared with someone who are not using outlook. I have tried using the
export feature in outlook without success, (File - import and export - export
to a file - microsoft excel - select 'Contacts'), as this only export the
contacts, but not the distribution list or their contents. Please assist,

Windows XP Pro, Outlook 2003, Excel 2003. Many thanks in advance,
 
S

Sue Mosher [MVP-Outlook]

Save the list as a .txt file. Open it in Notepad. Remove the few lines at the top so that only the names and addresses remain. Save it, and you will have a nice tab-delimited file that Excel can open.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/export: distribution Lists 1
Why can't I export "Distribution list" Ms outlook 2003? import Gmail 9
Export distribution list into excel 2
How do I export a distribution list from my address book to Excel? 4
export distribution list to excel 4
Export Distribution List from Outlook 2003 and Import into Outlook 1
Distribution List Question 2
How to Export & import contacts in a distribution list ? 4

Top