I have list with below structure
Name Email ABC ABC@bt.com XYZ XYZ@bt.com WER WER@bt.com
I would like to be able to send an email to all the email addresses which are on this list. The entries in this list will increase gradually so I want whenever an email is sent it should be sent to all those are under the Email column.
I wasn't able to find an easier straightforward solution to this problem. Please assist with your expert guidance.
If this can't be done, is there a way I can dynamically add users to a dummy group when a new entry is created in this list based upon any condition. For example, if a user entry is added to the list with designation as "consultant", that email should be automatically added to the consultant dummy group which I could later use to send email in a SharePoint workflow.
Is there a way I could do something like this
Name Email Variable ABC ABC@bt.com firstname.lastname@example.org;email@example.com;firstname.lastname@example.org XYZ XYZ@bt.com WER WER@bt.com
Whenever a new entry is added to this list, workflow to be able to concatenate all the email addresses to a single field which can be again used to send emails to all the addresses ?
Thanks for your help in anticipation.
I tried the solution with the below workflow
For example, if I add first entry as email@example.com, it will be coped into the new Email master list. Then if I add another entry in the parent list as firstname.lastname@example.org, the final result in email master would be ;email@example.com.
It just keeps the last email entry with a preceeding ;