Send workbook draft attachment through email

Send workbook draft attachment through email

Hi I love your platform, i saw a code to send the worksheet as an attachment through email like this

 ThisWorkbook.HasRoutingSlip = True 

   With ThisWorkbook.RoutingSlip 

     .Recipients = Array("xxx@yyy.com","zzz@yyy.com") 'Can send mail to multiple recepients

     .Subject = "Task completed" 

     .Message = "Mail content" & Target.Row 'Sending cell value in mail

     '.AttachWorkbook = False 

     ' By default the file will be attached in the mail. If it is not needed then send 

     ' .AttachWorkbook as false. 

    End With 

     ThisWorkbook.Route 


The problem is this sends the original file without changes. I wanted my team to access the excel spreadsheet, edit it, and send the edited version through email via macro, without having to grant permissions to save/export the file. Is this possible?

Thank you very much
Best regards