Hello,
I have the below code but I am looking to add something to it. Once the Macro has run but before the message box stating update complete, what I would like it to do is:
go to Sheet "CAPA Log", copy rows A1:P1, paste in an e-mail, then copy the last row with data (A:P) and paste that...