Extracting Names & Info from an Outlook distribtuion list to Excel

C

Cynthia in Seattle

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
 
C

Cynthia in Seattle

Txt would be fine - how?

Thanks!

Russ Valentine said:
No.
The closest you can come is to save it as a txt file.
--
Russ Valentine
[MVP-Outlook]
Cynthia in Seattle said:
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
Click to expand...
Click to expand...
 
S

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



Russ Valentine said:
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
Click to expand...
Click to expand...
 
R

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]
Cynthia in Seattle said:
Txt would be fine - how?

Thanks!

Russ Valentine said:
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
Click to expand...
Click to expand...
Click to expand...
 
R

Russ Valentine [MVP-Outlook]

So you're saying GAL's are different? I always thought as much.
--
Russ Valentine
[MVP-Outlook]
Sue Mosher said:
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



Russ Valentine said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top