Is there a way that I can use sendmail to send a pdf of the print area?

I have 40 spreadsheets in a workbook but only the print area in each
worksheet is the sales dashboard. The rest of each worksheet goes to
creating the output in the dashboard area.