Extracting addresses for auto-emailing

[ChuckDrago]

Hi everyone,
I created an application whereby the user is required to communicate data via email to specific users. The current methodology requires the user to fill up a table with the intended destinations and then Excel takes over and generates the appropriate emails. I was about to create a table with every name in the company so that the user selects, rather than type. Is there anyway to read the users from the Outlook Contact Lists, instead of me creating a table that varies with resignations and new hires? If so, I will appreciate a bit of help in the code.
Thank you, as always
Chuck

 

[Momentman]

See if this helps
https://wellsr.com/vba/2016/outlook/export-outlook-address-book-to-excel/

 

[ChuckDrago]

See if this helps
https://wellsr.com/vba/2016/outlook/export-outlook-address-book-to-excel/

Momentman, that is exactly what I needed... Great finding! Many thanks!!!
Chuck

 

[Momentman]

You are welcome. Glad to help

 

[ChuckDrago]

You are welcome. Glad to help

Momentman (and whoever reads this message in the future): the macro located in the link you provided above failed to render the clean data I wanted. Fortunately, its author (Ryan Wells) responded to my request for assistance and clarified that the reason it did not work as intended was my company using an Exchange Server. Ryan kindly provided me with the required slight modification and his macro worked like a charm.
If anyone goes to above link, make sure to read the correspondence we exchanged, if the same problem is experienced.
Thanks again (and kudos to Ryan).
Chuck