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