Google Sheet: Get the range of the specific cells and send it to email as an PDF file

I'm trying to send a PDF file attachment but I only want to send the data in a specific range. I saw a code here on how to send an email and it kinda works, but it generates all the visible sheets (hidden sheet is not included) in the PDF file. I declared a named range on that range that I want and it's called "print_area_1". I only want the "print_area_1" to be in that PDF file attachment. Is that possible?

Here's my modified code for it.

Please Login or Register  to view this content.