Create Public Email Group using VBA

[jsdba]

I'm almost sure this is possible but i'm not sure how. I want to create an Public Email Group in AD/MS Exchange (not sure which or both) from my access application.

Something like this:

Lets say i have 2 members:
'person1@mycompany.com'
'person2@mycompany.com'

I want to create 'group1@mycompany.com'.
Then add the two emails above.
I also need to be able to delete or add new emails to the group at any time.

I don't have any experience using exchange or AD so my naming might be off.

 

[Minty]

There is no way to get to the Exchange database from Access or even SQL server that I am aware of. It would be a security nightmare to be honest.

 

[jsdba]

There is no way to get to the Exchange database from Access or even SQL server that I am aware of. It would be a security nightmare to be honest.

http://www.tek-tips.com/viewthread.cfm?qid=1659755

This link demonstrates how to create a user in exchange. i'm assuming if this is possible then creating a group (dynamic distribution list as per my IT manager) is possible.

I need to create a "dynamic distribution list" in exchange consisting of the emails/users that already exist.

 

[Minty]

I stand corrected. I was sure there were security settings that prevented you getting to AD by via (effectively) application objects.

 

[jsdba]

Nobody has any ideas?