export distribution list to excel

[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

 

[Brian Tillman]

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.

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.

 

[Brian Tillman]

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.

Oops. I didn't read far enough. Sorry. You may be correct. DLs have
limits.

 

[Dave]

Oops. I didn't read far enough. Sorry. You may be correct. DLs have
limits.

Darn. Well I hope someone knows of a tool or something I can use!
DAve

 

[Karl Timmermans]

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