Using Automation to get Outlook email addresses

[Simon]

I have an Access 2000 form that can be used to email reports. What I'd like
to do is to fill a combobox on my Access form with all the email names &
addresses that are in Outlook so the user can choose an email from the list -
rather than have to know what it is and type it in.
I can't seem to find any examples of how to do this. I'd sure appreciate it
if someone could show me how to do this.
Thanks

 

[Arvin Meyer [MVP]]

You can export all of them from Outlook to an Access table. Look in the FileExternal Data and changing the Files of Type dialog to Outlook(). I usually
do the Outlook export because it's faster and you have control over not
exporting duplicates.