Create distribution list from a SharePoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-838063%22%20slang%3D%22en-US%22%3ECreate%20distribution%20list%20from%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838063%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20with%20a%20names%20column%20and%20an%20emails%20column%2C%20like%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EName%3C%2FTD%3E%3CTD%3EEmail%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELouise%3C%2FTD%3E%3CTD%3Elouise%40mail.com%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJack%3C%2FTD%3E%3CTD%3Ejack%40mail.com%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHanna%3C%2FTD%3E%3CTD%3Ehanna%40mail.com%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20now%20if%20it%20is%20possible%20to%20create%20a%26nbsp%3Bdistribution%20list%20containing%20all%20the%20emails%20from%20the%20email%20column%3F%3C%2FP%3E%3CP%3ESo%20that%20I%20can%20go%20to%20my%20Outlook%20and%20send%20an%20email%20to%20that%20specific%20list%20of%20emails.%3C%2FP%3E%3CP%3ESo%20that%20I%20don't%20have%20to%20manually%20insert%20every%20single%20email%20into%20the%20'%20to%3A%20'%20field%20in%20Outlook%2C%20but%20it%20would%20be%20something%20like%3C%2FP%3E%3CP%3E'%20to%3A%20thenameoftheemaillist%20'%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELouise%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-838063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-838112%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20distribution%20list%20from%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-838112%22%20slang%3D%22en-US%22%3E%3CP%3EDepends%20on%20the%20permissions%20you%20have%20I%20suppose.%20As%20an%20%22end%20user%22%2C%20you%20can%20sync%20the%20list%20to%20Outlook%2C%20copy%20the%20addresses%20to%20your%20contact%20list%20and%20create%20a%20%22contact%20group%22%2C%20which%20you%20can%20then%20address.%20If%20you%20want%20others%20in%20the%20company%20to%20be%20able%20to%20use%20the%20group%2C%20you%20will%20have%20to%20create%20it%20as%20a%20Distribution%20group%20in%20the%20GAL%2C%20and%20for%20that%20you%20need%20the%20necessary%20permissions%20on%20Exchange%20side.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842072%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20distribution%20list%20from%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842072%22%20slang%3D%22en-US%22%3ESync%20wise%20not%20really.%20However%20you%20can%20probabaly%20use%20flow%20to%20accomplish%20this.%20Using%20a%20trigger%20on%20the%20list%20and%20using%20the%20get%20items%20action%20and%20then%20use%20some%20action%20for%20distro%20groups%20if%20there%20is%20one%20to%20clear%20the%20list%20and%20then%20add%20all%20the%20users%20back%20or%20something%20along%20those%20lines.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842073%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20distribution%20list%20from%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842073%22%20slang%3D%22en-US%22%3EWell%20scratch%20that.%20Can%E2%80%99t%20find%20a%20connector%20for%20it%20%3A(%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842097%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20distribution%20list%20from%20a%20SharePoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842097%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403780%22%20target%3D%22_blank%22%3E%40Loubnielsen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20best%20way%20I%20can%20think%20to%20achieve%20this%20is%20to%20use%20Microsoft%20Flow.%3C%2FP%3E%3CP%3EYou%20can%20create%20an%20Office%20365%20group%20in%20Flow%20and%20get%20emails%20from%20SharePoint%20list%20and%20add%20to%20the%20group.%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you%20can%20send%20emails%20to%20that%20group.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130570i88AEC4017865F087%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi

 

I have a SharePoint list with a names column and an emails column, like:

NameEmail
Louiselouise@mail.com
Jackjack@mail.com
Hannahanna@mail.com

 

I would like to now if it is possible to create a distribution list containing all the emails from the email column?

So that I can go to my Outlook and send an email to that specific list of emails.

So that I don't have to manually insert every single email into the ' to: ' field in Outlook, but it would be something like

' to: thenameoftheemaillist ' 

 

Thanks in regards,

 

 

Louise

 

 

4 Replies

Depends on the permissions you have I suppose. As an "end user", you can sync the list to Outlook, copy the addresses to your contact list and create a "contact group", which you can then address. If you want others in the company to be able to use the group, you will have to create it as a Distribution group in the GAL, and for that you need the necessary permissions on Exchange side.

Sync wise not really. However you can probabaly use flow to accomplish this. Using a trigger on the list and using the get items action and then use some action for distro groups if there is one to clear the list and then add all the users back or something along those lines.
Well scratch that. Can’t find a connector for it :(

Hi @Loubnielsen 

 

The best way I can think to achieve this is to use Microsoft Flow.

You can create an Office 365 group in Flow and get emails from SharePoint list and add to the group. 

Then you can send emails to that group.

clipboard_image_0.png