How to achieve this save and mail merge button please?

[Nitrix]

how can I achieve if the mail merge button on the menu is selected a mail merge should run (using the Customer data on Sheet 2?

Also when my save button is clicked it then ensures the active sheet should be saved as a new workbook with the naming convention: SheetName_(CustomerNo_DD.MM.YYYY) and creates a (hidden) row at the bottom of the invoice with Invoice number, Invoice date, Customer number and Invoice total as well as cppy the row at the bottom of the invoice to the next available row in Sheet 7?

Thanks

[Nitrix]

oh yeah forgot to add that piece