Create distribution list from a SharePoint list

Loubnielsen 

I figured out an alternative solution to creating a workflow that might work.

1. Create your contact list in Sharepoint

2. Return to Classic SharePoint -> List -> Connect to Outlook

3. Accept to connect list to Outlook

4. Outlook should open with the Sharepoint list in the Contacts section. At this point I moved the list into the "Other Contacts" folder to keep it visibly separated 

5. Create a new folder under "My Contacts" (Right click on your email account and select New Folder).

• Name it whatever you want
• Folder Contains: Contact Items

6. Copy the contents from the "Other Contacts" list from step 4 into you new folder from step 5

7. Once copied over, create a New Contact Group

8. Name it whatever you want (I found prefacing the name with a 1. will keep it at the top of any list and easy to find) -> select Add Members

9. From the Address book drop down locate and select the contact folder from step 5

10. Select all -> click Members -> Ok...save and close your new contact group

Now, when you go to compose a new email, To -> Locate and select step 5 contact folder from Address Book drop down ->Click on the Distribution list you created in step 10

Currently I have alerts set up on my Sharepoint list to let me know of any changes. I am then triggered to go into my contact folder from step 5, delete its contents and re-copy/paste the freshly updated list from step 4. Repeat steps to create the distribution group etc...