I am trying to output a result of a query to an email. There are three collections which are being sent like this in a body:
Your course {{run_a_queryallcourses.result__rows__0__name *}} starts at {{run_a_queryallcourses.result__rows__0__StartDate *}} - see our website at {{run_a_queryallcourses.result__rows__0__permalink *}}
This is fine, but I’d like to add a greeting and a few words before the list of courses as well as a goodbye after. But if I add it like this
Dear user,
thank you for your question.
Your course {{run_a_queryallcourses.result__rows__0__name *}} starts at {{run_a_queryallcourses.result__rows__0__StartDate *}} - see our website at {{run_a_queryallcourses.result__rows__0__permalink *}}
Good luck
then I have the greeting and everything repeated too.
So how do I list those three collections and not repeat the rest? I thought about listing the collection with the &/&& notation, but it does not allow me to list the collections by one item: I get all names first, then all dates and then all links.
Any suggestions?