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

    • Sticky Posts

    • Introducing Forms in Zoho Sheet

      We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
    • What's new in Zoho Sheet: Simplify data entry and collaboration

      Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally
    • Slicers are now available in Zoho Sheet—filter your data interactively

      At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
    • Introducing Data Bars: Graphically represent changes in data within the cells

      Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method
    • Feature enhancement: Highlight rows based on a cell value

      Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw