Extracting Names & Info from an Outlook distribtuion list to Excel

[Guest]

I would like to export a distribution list from the Global Address list
(Outlook 2002) to either an Excel file or a text file. Can this be done -
and if so, how???

Thanks!
Cynthia

 

[Russ Valentine [MVP-Outlook]]

No.
The closest you can come is to save it as a txt file.

 

[Guest]

Txt would be fine - how?

Thanks!

No.
The closest you can come is to save it as a txt file.
--
Russ Valentine
[MVP-Outlook]

I would like to export a distribution list from the Global Address list
(Outlook 2002) to either an Excel file or a text file. Can this be done -
and if so, how???

Thanks!
Cynthia

 

[Sue Mosher [MVP-Outlook]]

Actually since this is a GAL DL, you can't save it. There are some other
approaches listed at http://www.slipstick.com/contacts/print.htm#gal

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

No.
The closest you can come is to save it as a txt file.
--
Russ Valentine
[MVP-Outlook]
in
message news:[email protected]...

I would like to export a distribution list from the Global Address list
(Outlook 2002) to either an Excel file or a text file. Can this be
done -
and if so, how???

Thanks!
Cynthia

 

[Russ Valentine [MVP-Outlook]]

Doesn't the Save as... menu allow you to do that?
Excel will recognize the file as tab delimited. You may need to remove the
name of the DL from the top so Excel can import it correctly.

--
Russ Valentine
[MVP-Outlook]

Txt would be fine - how?

Thanks!

No.
The closest you can come is to save it as a txt file.
--
Russ Valentine
[MVP-Outlook]
message news:[email protected]...

I would like to export a distribution list from the Global Address list
(Outlook 2002) to either an Excel file or a text file. Can this be done -
and if so, how???

Thanks!
Cynthia

 

[Russ Valentine [MVP-Outlook]]

So you're saying GAL's are different? I always thought as much.
--
Russ Valentine
[MVP-Outlook]

Actually since this is a GAL DL, you can't save it. There are some other
approaches listed at http://www.slipstick.com/contacts/print.htm#gal

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

No.
The closest you can come is to save it as a txt file.
--
Russ Valentine
[MVP-Outlook]
in
message news:[email protected]...

I would like to export a distribution list from the Global Address list
(Outlook 2002) to either an Excel file or a text file. Can this be
done -
and if so, how???

Thanks!
Cynthia