Macro to email content of pivot table to assigned recipient

[pcorpz]

Hello excel gurus! Basically I have a pivot table report grouped by Sales Rep. I need help in creating a macro that will send an email to each Sales Rep with only their specific data pasted to the body of the email including the pivot header/label (A5:H5). Here is a screenshot of my pivot table:

https://www.dropbox.com/s/6y2ntoy12nrrt0q/pivottable.PNG?dl=0

Any help would be greatly appreciated! Thank you