Excel payroll workbook that Generates pay slips as PDF and mail automatically to individual emails

Excel payroll workbook that Generates pay slips as PDF and mail automatically (outlook) to individual emails.

in the attached fake payroll sheet, you can see the columns ( salary, earnings, deductions and net salary) per employee.

I want a button to generate a PDF and send it to each employee in the sheet via outlook

later will agree on how the PDF and outlook email details