Mail only visible cells with conditional formatting

Hello,


I am looking to set up a button in my spreadsheet that can mail selected cells with conditions formatting. To achieve this I am trying to modify the following piece of code which copies selected cells, with conditional formatting in to an email. However it also carries across hidden cells.

Is anyone able to offer any guidance on how to modify this code, to only copy across the visible cells and keeping the conditional formating

Protonspounge

HTML Code: