Exporting SMTP Addresses from Global Address List 1

[Sunny4Ever]

Hi All

Bit of a tough one: I need to get my Exchange 5.5 Global Address list exported to someone on another Exchange / Outlook 2000 system. I only want to export items with a valid SMTP address and I only wish to export SMTP addresses. Ideally I want these to be in a contacts folder in a .pst but csv would be fine - I think it is impossible but would love to be proved wrong!

Any ideas?

Cheers

 

[andyrob]

Can't you do a directory export from the GAL on the server, picking what you want and then do some sort of jiggery-pokery with the CSV data in Excel or Access ?

 

[Sunny4Ever]

Cheers Andy/Rob/AndyRob

..........poorly documented menu option!

once in Excel ran a few string functions and conditionals and I had a list of addresses with valid SMTP addresses and a short hop back into .pst and I was sorted.