ArdeviaForum

How to send an email to a list of addresses saved in a separate list

Discussion created by ArdeviaForum on Aug 18, 2016

Original Post by Andrii Katsiubka (Imported from Ardevia Forum)

To send an email to a list of addresses saved in a separate list, please perform the following steps:

  • Open Expression builder for CC option
  • Set expression type to  "Assignment" (at the top of Expression builder)
  • Copy the following expression and paste it into the builder editor:

    Code:

[[@Web.GetValuesForQuery('<ListName>', '<CamlQuery>', '<EmailFieldName>')]].join(';')

 

  • Replace <ListName> with the name of your list that contains Emails
  • Replace <CamlQuery> with your query to filter emails (set  '<Query><Where></Where></Query>' if you want to send to all from the list )
  • Replace <EmailFieldName> by Field Name related to email address
  • Save expression and save action

Note: In Send Mail Action "To" option also should be defined.

Outcomes