VBA Copy to Email Not Working

Hi all,

I'm left dumbfounded at this issue i'm facing.

I have a hefty load of code that does all sorts of things, then the easy part is to copy this information from 1 sheet to an email via the Ron DeBruin method.

A little background, Monday to Thursday, the formula works fine. When it comes to a Friday, the data just doesn't paste, the email opens with all the correct recipients and attachments and what not, just not the data from the sheet.

I've attached the spreadsheet for perusal.

Can anyone help pretty please? Happy to elaborate if needed.