Email as PDF attachment for multiple recipients

Hi all,

I would like to be able to attach a worksheet as a pdf in outlook based whether a checkbox is selected for that sheet. I have attached a basic model of what I would like to accomplish. There are five sheets for five customers each with an different email address. I would like to select which ones will get an email, press a button to email them and generate the separate email for each with their respective sheet as a pdf attachment.

Your help is always appreciated.

Ken