Want to send email to client so my requirement is
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
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
Use the excel activity 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.
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
How I convert data table output into string
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
Output Data Table (uipath.com)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.