Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to send SMTP mail using Qlik SMTP Connector from QlikWebConnectors.
I modified the script generated by Qlik SMTP Connector to create the script below.
In this script, is it possible to change the recipient by adding or deleting the recipient vMailRecipients value from the app sheet?
I don't think you can do that from a sheet in the app.
Because after processing the data in the script, I think the app's sheet is only used to display the processed data.
If I'm wrong, is there another way?
I need advice from the Qlik team.
Please reply if possible.
thank you.
Hello,
Are you storing recipient lists in the table in the data model? And you want to pull those recipients in the vMailRecipients dynamically?
If yes, then you can use peek() function to get the value and store in the variable and then pass the variable as value in Encode(variable,vMailRecipients).
If there are multiple recipients, you can use for loop to pick the emails one by one and call the subroutine in the for loop where you are creating email alerts.
Thanks.