Does anyone have any vba code to create an outlook distribution list from an Access table with fields for names and email links?

What I remember is that you first have to import all the names into your contacts or a new contacts list. Then you can create a distribution list from the contacts.

Since you are wanting VBA code to do this, does this mean you will be updating the distribution list form the Access data in the future?

I have found it works a lot better to keep the data in Access and use VBA code to send the emails from Access. I create my distribution lists in Access. This also allows the list to be shared with other users.

Ideally, yes I would like to be able to update my Outlook distribution list from my Contact Access database table everytime there is a new name and email added.

What is your VBA code to send Outllook emails from your Access database?

Thanks.