Fellow Excel MVP, Orlando, has a new utility called PrintThru Email. It sends, via email, a workbook that only includes what would have been printed from your workbook. Things like filtered data and hidden rows and columns are removed.
I’ve messed around with it a little and it seems to work pretty well. I did encounter a couple of minor problems, and Orlando is fixing (or has fixed) them. Check it out.