I am trying to filter col F "Days To Expiry"in table for a value of 5 and then copy and paste all those rows to body of email in outlook. I used a VBA from here and it copys the table with no data in it, any chance someone has the vba for this.
rvmurphy
You should able to send a sample Excel-file here
which have You named VBA-code.
There are 'some' challenges to figure any changes based Your sent picture.