I have one straight table on which every row contains email and product , i just want to send alert email to email id with message content as its product name.
In my particular case, every morning I reload a document that reads the whole Active Directory and then sends a message to the users whose password is between 50 and 59 days.
For this, I created an Alert in the document.
In the Alert, I fill the Description, Message, and Mail Subject with a standard text. I fill the Mail Recipients field like this:
=concat({$ <PasswordAge={">=50<=59"}>} mail,';')
The mail field holds the email address of the user. This sends THE SAME MESSAGE to all the users (I have not found a way to include the PasswordAge in the message body), so I am not sure this is what you are looking for.
sorry for the delay, I have been disconnected for several days.
Regarding your question, I have not been able to personalize that message, and as Gysbert says below, "Afaik it's not possible to send 1 alert with different messages for each recipient. You will have to create separate alerts for each row"
