I really could do with some help.
I am trying to send the info from cells A1:G38 as the body of my email.
I need two options to send the same data one for a day shift and one for a night shift this is due to the automated subject line.
The code sends the email just the body of the email is always blank any ideas? Also when I add the second function (Night shift) using the same code as I used for the (day shift) the macro doesn't run at all?
I am new to VBA but enjoying the challenge.
Thank you in advance.
This is the code I am using, and I have attached the excel spreadsheet.
PLC Shift report.xlsm
Bookmarks