1) We have to update an excel file, and then copy the used range in the excel file to a mail. We are able to get the used range using the steps provided at: https://collaborate.pega.com/discussion/pega-robotics-excel-how. But how do we proceed with the next step of copying this range and pasting to an email. I do see that the range object, has a copy method, but it is unclear how to copy to clipboard and then paste from clipboard to an email
Please provide some inputs on how these can be achieved.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
We do not want to convert the data to string and then process it as it adds overheads, want to check if there is any option to use the copy/paste option. When we do it manually, you just have to select the range in excel and copy it and then go to outlook and paste it. Want to see if there is any option to mimic it
There's no paste() method for the mail connector, you'll have to manipulate the data to pass it to the email. Services can assist you with this, or you can open an SR as a feature request to have the paste() method added to the mail connector.