How can I export a distribution list to excel?

  • Thread starter Thread starter patrick.horsman
  • Start date Start date
P

patrick.horsman

Since moving to an exchange server our DL is too large and I just get
an error when I go to send an email... How can I export a distribution
list to excel?
 
DL's never survive exporting. What makes you think you want to do that?
 
FIle | Save As. If you save the DL as a .txt file, you can open it in Notepad, remove the non-address information at the top, then open it in Excel as a tab-delimited file.

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Since moving to an exchange server our DL is too large and I just get
an error when I go to send an email... How can I export a
distribution list to excel?
Click to expand...

Open the DL and click File>Save As and choose a txt file type. The DL will
be saved as a Tab Separated Values file and Excel should be able to open it.

That said, I don't know what you can do with it aferward because there's no
way I know to import to a DL.
 
Back
Top