I need to export a Distribution List to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles - 06 Jan 2005 20:47 GMT

I need to export a Distribution List to Excel. Not individual Contacts.
Outlook 2000 Exchnge Server 5.5.

Thanks!

Signature

Charles

Reply to this Message

Sue Mosher [MVP-Outlook] - 06 Jan 2005 21:07 GMT

File | Save As. If you save it as a text file, you can open it in Notepad
for some minor massaging to remove all but the tabular data, then open the
resulting file in Excel as a tab-delimited file.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I need to export a Distribution List to Excel. Not individual Contacts.
> Outlook 2000 Exchnge Server 5.5.
>
> Thanks!

Reply to this Message

Charles - 07 Jan 2005 07:25 GMT

Russ & Sue -

Thanks! That helped. Anyway I can then import that Excel file into a
Global Distribution List on Exchange Server 5.5? Alternately, is there
anyway to bring them in individually on a global list?

Thanks!

> File | Save As. If you save it as a text file, you can open it in Notepad
> for some minor massaging to remove all but the tabular data, then open the
[quoted text clipped - 4 lines]
> >
> > Thanks!

Reply to this Message

Russ Valentine [MVP-Outlook] - 06 Jan 2005 21:35 GMT

You can't export DL's. You can save them as txt files then open them in
Excel.

Signature

Russ Valentine
[MVP-Outlook]

>I need to export a Distribution List to Excel. Not individual Contacts.
> Outlook 2000 Exchnge Server 5.5.
>
> Thanks!

Reply to this Message