Posts by Jiro

Re: Expand Outlook Distribution List using Excel VBA

Thanks ashu1990 - but it says "Distribution List doesn't exist" yet I'm sure that the Distribution list was typed correctly. Is there any other settings or variable value that I need to change, like GetDefaultFolder? I am using our Global Address list.

Hi,
I'm trying to write a macro that would expand an outlook distribution list so I can see the names. Then copy the names in a one sheet.

Any help please?

Thanks,

Jiro