Looping through Filter and then copying the data so I can paste or put into outlook body

I currently have a spreadsheet where I filter by Rep Name and then I copy the filtered the results into an email and send to each rep individually. Just trying to automate this through code where it will filter by each rep listed then copy the data (as a range??) so I can copy or even load an outlook email.

I have attached a dummy test workbook with the data as well as screenshots of the email I currently send at the bottom of the data.

Thank you for any help or direction.

Josh

Thank you John & Leith for the reply and help. I downloaded Leith's workbook and it does exactly what I was looking for and I haven't had a chance to check out John's reply from this AM. One question I have, is there anyway to have the subtotal line BOLD or BIGGER FONT or even an extra space? How I was doing it currently was adding a blank like so it was easy to see the subtotal.

Thank you again,

Josh

Hi Leith,

For some reason I cannot get each rep to subtotal, just shows all the line items and is copied over to email just fine... but it is missing the subtotal...

Not sure if I am doing something wrong, I went back the original workbook you sent over and getting same results.

Thank you,

Josh

HI JOSH,

Thanks a lot........... codes shared by you is working fine BUT I DON'T WANT PAST DATA ON MAIL BODY INSTEAD OF IT I WANT TO ATTACHE IT AS EXCEL FILE WITH MAIL. Plz guide if possible ,for your help I will be indebted to you forever.