export distribution list to excel

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'm running Outlook 2003. I want to export a distribution list to Excel. The
list was among other contacts, so I moved it to its own "Job Listings"
folder, a subfolder of Contacts and of the contacts folder type.

I tried the Import/Export wizard, and it creates an excel file, but it turns
out it doesn't process any entries from a distribution list - only contacts.
I also tried a CSV file with the same result.

I opened the distribution list and selected File->Save As, saved as a text
file, but it gave me an error: "Out of memory or system resources. Close
some windows or programs and try again." I've got plenty of RAM, so I assume
Outlook just can't handle exporting such a large distribution list. The list
has like 3,000 or some odd members.

I also have a Personal Address Book version of it if that helps, which is
what it originally was. I had imported it into my Contacts folder thinking
that I would more easily be able to export it to Excel from there, because I
was having no luck exporting from the Personal Address book. But the
Personal Address Book has many contacts besides the distribution list I
need, so any export needs to be able to specify only that distribution list
inside it.

I'm getting the impression that I'm not going to be able to accomplish this
with Outlook. Is there a conversion utility out there?

Dave
 
Dave said:
I'm running Outlook 2003. I want to export a distribution list to
Excel. The list was among other contacts, so I moved it to its own
"Job Listings" folder, a subfolder of Contacts and of the contacts
folder type.
Click to expand...

Distribution Lists don't survive exporting. Instead, open it and click
File>Save As and save it as a text file. It will be a tab-delimited file
which Excel can handle.
 
Dave said:
I opened the distribution list and selected File->Save As, saved as a
text file, but it gave me an error: "Out of memory or system
resources. Close some windows or programs and try again." I've got
plenty of RAM, so I assume Outlook just can't handle exporting such a
large distribution list. The list has like 3,000 or some odd members.
Click to expand...

Oops. I didn't read far enough. Sorry. You may be correct. DLs have
limits.
 
Brian Tillman said:
Oops. I didn't read far enough. Sorry. You may be correct. DLs have
limits.
Click to expand...

Darn. Well I hope someone knows of a tool or something I can use!
DAve
 
ContactGenie Exporter Basic exports PDLs but unfortunately it's not a free
utility (link below if interested). Haven't run across a PDL this large but
size shouldn't be factor with the way CGX processes items.

Karl
_____________________________________________________________
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Back
Top