Here's a part of what you might need. This just saves a copy of the file using the current date in the filename.
I wouldn't trust a User to enter a date! They could put the wrong date in or use a wrong date format.
The code uses yyyy-mm-dd as this always automatic sorting of files in date order in the destination folder.
The code uses SaveCopyAs, leaving the template file with whatever name you started with.
You would need to link other routines to Clear data, Email file, Close file.
I would recommend that these be assigned to separate 'buttons'.
Code for saving file: