This drives me crazy. Here is a thread that seems to be talking about exactly what you want to do. It looks like they eventually get it worked out with publication using dynamic recipients, but do not say exactly how they did it.
I tried messing around with a publication. IMO, very confusing and poorly documented. Not surprisingly, I did not get it figured out.
BTW, I requested this functionality at the beginning of 2016.
https://influence.sap.com/sap/ino/#/idea/10004 (SAP login may be required)
It is marked as “Delivered” sometime in 2020. However, it seems the only thing delivered was the %SI_DATE% placeholder rather than the ability to format the date in any way we choose.