Hi @EmmanuelF,

There are two ways to read external data to use it in a Workflow:

• Read SQL Result (Read SQL Result :: Ataccama ONE) -- Reads data provided by a query to the variables defined by the mapping. You’ll need a database connection to query the data.
• Read File Variables (Read File Variables :: Ataccama ONE) -- Read data from a file. Right now, the only supported file type is a property file (a text file holding properties defined as key-value pairs in a format property.key=property.value)

For your case I think the latter suits better. So you need to ensure that DQC plan outputs data in a supported (property) format. Then read it using Read File Variables step and then you can use results of the Send Mail step using ${ewfGetTaskVariable("read_file_vars_task_name", "key")} syntax (more on the ewfGetTaskVariable function)

Hi @AKislyakov,
I have created the properties file and have passed it to the Read File Variable as below

Now when I pass this variable to the Send Mail as such

I get an error stating “Illegal address in string ``abc@xyz.com,efg@xyz.com''”
If the email contains only a single email id the mail is sent. How do I include multiple email ids?

To send email to multiple recipients email addresses should be separated by \r\n separator.

Manually it is possible to separate emails with this separator. What if I need to write a list of emails (These emails are fetched in the Run DQC Plan) with this separator in a .properties file using a text file writer?

I found the solution, Thanks for your help.