Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   How can I copy Distribution List into Word or Excel? (http://www.outlookbanter.com/outlook-using-contacts/28262-how-can-i-copy-distribution.html)

Angela March 16th 07 04:27 PM

How can I copy Distribution List into Word or Excel?
 
I used the steps tht you gave to save teh dl as a txt file, but how do I get
teh extended contact information for each of those individuals in that dl to
export? All it did was make the exact same list withthe emails into a text
form, but their addresses adn phone numbers, items thta I need exported did
not save alogn with it, what can I do?

"Sue Mosher [MVP-Outlook]" wrote:

Just save the DL as a .txt file.

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

"Dale Watson" Dale wrote in message ...
I'm using Outlook 2003 SP2. I have a large Distribution List, the contents
of which I need to share within our branch.

It would make perfect sense to be able to copy/paste this information into
Excel and/or Word; however this does NOT seem possible.

Is there "any" way to transfer this information - i.e. if not through some
"hidden" method of copy/paste, then perhaps an export/import method, or
perhaps through VBA?

Many thanks for any help offered.

If a solution is offered and if this is monitored by Microsoft staff, might
I suggest that this information should be made known to current users - i.e.
more prominently.

If a solution is NOT offered, might I suggest that Microsoft staff will want
to address this for a future release.

Thanks again.

Dale Watson



Russ Valentine [MVP-Outlook] March 17th 07 12:14 PM

How can I copy Distribution List into Word or Excel?
 
I don't understand. DL's do not contain any of that information. Clarify
what you are really trying to do. Doesn't sound like it has anything to do
with DL's.
--
Russ Valentine
[MVP-Outlook]
"Angela" wrote in message
...
I used the steps tht you gave to save teh dl as a txt file, but how do I
get
teh extended contact information for each of those individuals in that dl
to
export? All it did was make the exact same list withthe emails into a text
form, but their addresses adn phone numbers, items thta I need exported
did
not save alogn with it, what can I do?

"Sue Mosher [MVP-Outlook]" wrote:

Just save the DL as a .txt file.

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

"Dale Watson" Dale wrote in message
...
I'm using Outlook 2003 SP2. I have a large Distribution List, the
contents
of which I need to share within our branch.

It would make perfect sense to be able to copy/paste this information
into
Excel and/or Word; however this does NOT seem possible.

Is there "any" way to transfer this information - i.e. if not through
some
"hidden" method of copy/paste, then perhaps an export/import method, or
perhaps through VBA?

Many thanks for any help offered.

If a solution is offered and if this is monitored by Microsoft staff,
might
I suggest that this information should be made known to current users -
i.e.
more prominently.

If a solution is NOT offered, might I suggest that Microsoft staff will
want
to address this for a future release.

Thanks again.

Dale Watson






All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com