Email selected print section to address located in a cell instead of email address in code

I am using the code below in conjunction with a button labeled "Modification Notification". When pressed, it is supposed to automatically creates a PDF out of the printable section of the the worksheet on which it is located, and then email it to a specified recipient. It works, except right now it makes a PDF out of the entire workbook, and then emails it to the specified email address located within the code. Instead, I need for it create only a PDF for the printable section of the worksheet on which the button is located. Secondly, instead of entering an email address into the code, I prefer it pull the email address from cell "F8" on the worksheet labled "Menu".

Thanks in advance to anyone who may assist me!

Please Login or Register  to view this content.