Hi Matelot,
Well it is possible to lash something together with a macro, but it will all be a bit 'Heath Robinson'. It will be really brittle and lack error checking and fault tolerance. But if you must here is a start:
https://support.microsoft.com/en-us/kb/816644
What you are doing is more of a database task and there are plenty of freeware Content Management Systems which would provide a clean web based front end to do the data entry, user management and fully automate the production and sending of the emails. That is the way I would do it.
EG