I have been able to get the file working as per your specs. Note columns from Q to AA are also included in the email report. If you can move the email column over I can update the code. The email vlaue has to be in the selected range for this method to work. Other Notes: This code writes to Range BB and then deletes that data. It also creates new worksheets that are then deleted. I leveraged the page below.
I used information from two primary sites to make this code work. This code helped with the emailing part https://www.rondebruin.nl/win/s1/outlook/bmail2.htm
and this helped with the filtering part.
https://www.listendata.com/2015/04/e...asting-to.html
Let us know if you have any questions.
Bookmarks