VBA Copy to Email Not Working

[Frankinstyyn]

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.

[davesexcel]

Hi Frankinstyyn....
What are we supposed to do when we have the sample workbook opened?

[Frankinstyyn]

Hi Frankinstyyn....
What are we supposed to do when we have the sample workbook opened?

Hello, thanks for looking.

It should run the macro for you. It should also open an email and have the data in it but it doesn't seem to work.

On the 'grids' sheet, the grey box runs the macro.

Hope that helps.