Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Exporting Distribution Lists to Excel or other
0 views
Skip to first unread message
Benjamin
Aug 12, 2004, 9:11:40 PM8/12/04
to
I need to export all the email addresses in my DL's to
Excel. I've tried using the Export function and it seems
I need to create the Excel doc first and format it
somehow so the addresses come through. I've also tried
exporting to alternative file types to then cut and paste
into excel but no luck withthe other formats either.
Please explain step-by-step how to Export correctly. All
the DL contacts are listed as their name being 'a' and
their address with no other info.
Excel. I've tried using the Export function and it seems
I need to create the Excel doc first and format it
somehow so the addresses come through. I've also tried
exporting to alternative file types to then cut and paste
into excel but no luck withthe other formats either.
Please explain step-by-step how to Export correctly. All
the DL contacts are listed as their name being 'a' and
their address with no other info.
![Sue Mosher [MVP-Outlook]'s profile photo](https://lh3.googleusercontent.com/a/default-user=s40-c)
Sue Mosher [MVP-Outlook]
Aug 12, 2004, 9:30:24 PM8/12/04
to
Use File | Save As to save an individual DL as text file. Open it in
Notepad, remove the lines at the top before the names and addresses, then
save. You should now have a nice tab-delimited tab file that Excel can
handle.
Notepad, remove the lines at the top before the names and addresses, then
save. You should now have a nice tab-delimited tab file that Excel can
handle.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"Benjamin" <anon...@discussions.microsoft.com> wrote in message
news:56c901c480d2$7cf89590$a601...@phx.gbl...
0 new messages