To use it in the mail body, you need to have it in the workflow additional data.
For your example use case:
* Query the recipients to receive the mail
* In a parallel parh query the workflows based on date info
* Uae an enrichment with type collection link
* Add the link to additional data, choose the fields you need and the max number of rows
Then you can use it in the email body