Mailing a Selected Range in the Body and Attachments From Excel

I had to develop this functionality for work and decided to extract it for more general use.

We have a dashboard-like report where people select a vendor and a chart showing the metrics for that vendor appear. Simultaneously, the subset of data that drives the chart is extracted into a spreadsheet.

The user clicks a button, and an email is launched. I use .display so the users can edit the email before sending it. The message is generated with the spreadsheet as an attachment and chart embedded in the body of the mail message.