Forum Discussion

nehabish6's avatar
nehabish6
New Contributor
8 years ago

Send email notification to specific users using schema data

We have a SQL table which contains the user mail ID and the comments/approval submitted by the user on a given date. Now I require to send out mail notification to dynamic user with details to notify...
aniketbhoi's avatar
aniketbhoi
New Contributor II
8 years ago

Can the data not be put into an HTML table so that snap treats it as one document ,so that users receive one email with their respective pending actions against their names in a table.

aleung's avatar
aleung
Contributor III
8 years ago

You can and you would need to use “group by” to get it back to an single document. As for formatting the array, that part would be something you need to play with a bit. Another thing you can try is to use CSV formatter to get it in a delimited form.