# Email list **URL:** \ **Category:** Ask for Help\ **Created:** [January 25, 2022, 12:07pm UTC](https://community.glideapps.com/t/email-list/37665 "2022-01-25T12:07:21Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [January 25, 2022, 12:07pm UTC](https://community.glideapps.com/t/email-list/37665/1 "2022-01-25T12:07:21Z")
Table contains records (users) with a field with an email. An inline list is showing lines (users) based on different criteria. Once selected I would like to send an email to all of the selected - is there an elegant way to concatenate the emails into a field? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 25, 2022, 12:56pm UTC](https://community.glideapps.com/t/email-list/37665/2 "2022-01-25T12:56:43Z")
The easiest method would be to use a choice component with multi-select, which will give you a comma delimited list of selected emails. If you would rather use the inline list, then I assume you are using a checklist style layout and setting a user specific boolean column. In that case, in addition, you will need an IF column that will return the user’s email address if the selected boolean value is true, else return nothing. Then create a joined list column that will return a comma delimited list of emails from from the selected IF column that you created above. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 25, 2022, 2:32pm UTC](https://community.glideapps.com/t/email-list/37665/3 "2022-01-25T14:32:56Z")
you can loop this script for all join lists like @Jeff_Hager said, and have a great representation of your brand… > **[Email Center Demo](https://email-center-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AZQBtAGEAaQBsACAAYgB1AHQAdABvAG4AIgAsACIAcgAiADoAIgBNADIAcwBuAC4AYQBhAFoAUgBBAE8AcABFAGMAUABmAE8AcwBOAFMAVABnACIAfQA=)** > > create a customized, automatic email responses and the plus is… users do not need to have a browser synchronized to an email service ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [February 2, 2022, 6:56am UTC](https://community.glideapps.com/t/email-list/37665/4 "2022-02-02T06:56:12Z")
Jeff Thanks for the quick response, my inline list is a list of records (reports) where several employees have several entries. So if I use a “joined list” I end up with a bunch of repetitive strings. Is there a simple way to get a unique list? Manual entry would be too tedious… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 7:00am UTC](https://community.glideapps.com/t/email-list/37665/5 "2022-02-02T07:00:05Z")
You can remove duplicates from a Joined List in two steps: - Step 1: Use a Split Text column to turn it into an array - Step 2: Use the [Unique Elements](https://www.glideapps.com/plugins/uniq) plugin to remove duplicates If you need it as a joined list, then you can use one more (Joined List) column to convert it back. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [February 2, 2022, 7:30am UTC](https://community.glideapps.com/t/email-list/37665/6 "2022-02-02T07:30:09Z")
Great, I am almost there, yet I can not reference the field in an email, do I need to convert this somehow? Many Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 7:41am UTC](https://community.glideapps.com/t/email-list/37665/7 "2022-02-02T07:41:09Z")
> [@Ganymed](#): > > yet I can not reference the field in an email I’m not sure what you mean by this. Do you mean the Compose Email action? ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [February 2, 2022, 7:52am UTC](https://community.glideapps.com/t/email-list/37665/8 "2022-02-02T07:52:58Z")
Yes, I have now a unique list of emails of contributors - I can include this field in the body or cc - it is not visible. Test 1 includes the redundant emails, the other 2 are according suggestion: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/985a023b19afa920ab07095e95547f7906307821.png) ](https://dl.dropboxusercontent.com/s/pvmfxx9f1ya45i7/Screen%20Shot%202022-02-02%20at%2008.49.22.png?dl=0) When I try to reference the result (unique) it is not visible: [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/5585a1de348b17678c29e3144ad39f84fb3a1d18.png) ](https://dl.dropboxusercontent.com/s/jvcx604wksegi3u/Screen%20Shot%202022-02-02%20at%2008.52.06.png?dl=0) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 7:54am UTC](https://community.glideapps.com/t/email-list/37665/9 "2022-02-02T07:54:24Z")
Yes, you just need one more Joined List column to change it back into a comma separated list. > [@Darren\_Murphy](#): > > If you need it as a joined list, then you can use one more (Joined List) column to convert it back. ---
**Author:** ![Ganymed](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ganymed/32/27001_2.png) [@Ganymed](https://community.glideapps.com/u/Ganymed)\ **Post date:** [February 2, 2022, 8:25am UTC](https://community.glideapps.com/t/email-list/37665/10 "2022-02-02T08:25:24Z")
Done, Thanks PS: Is there a reference where the logic behind these operations is described? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 9:41am UTC](https://community.glideapps.com/t/email-list/37665/11 "2022-02-02T09:41:33Z")
All of the computed columns are covered in the Glide Library. > **[Primary](https://docs.glideapps.com/all/topics/computed-columns/primary)** With some of them, it might not be immediately obvious how or when they can be used. This is something that just comes with experience. For example, for a long time I really had no idea what the point of the Single Value column was. Now I use it all the time 🙂 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 3, 2022, 9:41am UTC](https://community.glideapps.com/t/email-list/37665/12 "2022-02-03T09:41:53Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.