Want to send mail so in body of the mail I want excel cell A23 to B30

[rutuja.y]

Want to send email to client so my requirement is

1. Copy all the cell from A23 to B30 and paste into an email body
   Here I have excel file which path is stored in strSpreadsheetFilePath and in that file cell which I have to copy from “Auth Email” tab

2. copy the cell from A9 to D9 and paste in email subject line
   Here file and tab is same as mentioned above

Please guide in detail me how to copy paste cell in email

Note- want to use send outlook mail activity

[T0Bi]

Use the excel activity https://docs.uipath.com/activities/docs/excel-select-range to select your range (e.g. A23;B30).
Then send hotkey ctrl + c to copy.

Open Outlook (open application activity), create a new mail (click activity) and paste the table in the mail with ctrl + v.

This should do.

[rahulsharma]

User Read Range activity to get the required Range Data from Excel

Then, you can convert it into a string, using output data table and use it as a string input for the subject of your email, for email you may use any of the activities as per your convenience, Outlook, SMTP, Exchange

[rutuja.y]

How I convert data table output into string

[rahulsharma]

you can use “Output Datatable” activity for that. As you are putting the text in subject that would be one text, this will work. You may format the text also, like remove the separator “,” and adding “|” as that looks more better in subject lines

Official doc:
Output Data Table (uipath.com)