Thread: Emailing Worksheets

I want to e-mail a worksheet to a specific address that is based on information that is supplied by a PivotTable report filter.

When the user filters the report, they click a button within the worksheet that will e-mail the report to an address that is based on the value (or values) selected inside the filter. For example, if the user filters the report by "Practice A", when they click the button, the report will automatically be sent to the e-mail address of "Practice A". If they select "Practice B" and "Practice C", when they click the button, the report will automatically be sent to the e-mail addresses of "Practice B" and "Practice C". I hope this much is clear to anyone.

I'm thinking that my best bet is to write some VBA code, but I want to know if there are any other solutions to this problem.