Selecting data from Excel and sending an email in UiPath
up vote
-1
down vote
favorite
I have an Excel sheet with multiple columns, e.g. names, values, etc..The table is in the following format:
I want to compare values from both columns 'Value1' and 'Value2', so if Value1-Value2 > 0 then send email to corresponding user with the selected data as an attachment, in this case to the user 'Lastname4, Firstname4' (one row only).
Also, can we create the email address on the fly based on the column 'Name' in UiPath? In Excel the formula to do so for the 1st row would be something like this: =CONCATENATE(TRIM(MID(A2&"."&A2;FIND(",";A2)+1;LEN(A2)));"@domain.com")
Thanks
uipath
asked Nov 9 at 9:01
Jasu
558
add a comment |
up vote
-1
down vote
favorite
I have an Excel sheet with multiple columns, e.g. names, values, etc..The table is in the following format:
I want to compare values from both columns 'Value1' and 'Value2', so if Value1-Value2 > 0 then send email to corresponding user with the selected data as an attachment, in this case to the user 'Lastname4, Firstname4' (one row only).
Also, can we create the email address on the fly based on the column 'Name' in UiPath? In Excel the formula to do so for the 1st row would be something like this: =CONCATENATE(TRIM(MID(A2&"."&A2;FIND(",";A2)+1;LEN(A2)));"@domain.com")
Thanks
uipath
asked Nov 9 at 9:01
Jasu
558
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have an Excel sheet with multiple columns, e.g. names, values, etc..The table is in the following format:
I want to compare values from both columns 'Value1' and 'Value2', so if Value1-Value2 > 0 then send email to corresponding user with the selected data as an attachment, in this case to the user 'Lastname4, Firstname4' (one row only).
Also, can we create the email address on the fly based on the column 'Name' in UiPath? In Excel the formula to do so for the 1st row would be something like this: =CONCATENATE(TRIM(MID(A2&"."&A2;FIND(",";A2)+1;LEN(A2)));"@domain.com")
Thanks
uipath
asked Nov 9 at 9:01
Jasu
558
I have an Excel sheet with multiple columns, e.g. names, values, etc..The table is in the following format:
I want to compare values from both columns 'Value1' and 'Value2', so if Value1-Value2 > 0 then send email to corresponding user with the selected data as an attachment, in this case to the user 'Lastname4, Firstname4' (one row only).
Also, can we create the email address on the fly based on the column 'Name' in UiPath? In Excel the formula to do so for the 1st row would be something like this: =CONCATENATE(TRIM(MID(A2&"."&A2;FIND(",";A2)+1;LEN(A2)));"@domain.com")
Thanks
uipath
uipath
asked Nov 9 at 9:01
Jasu
558
asked Nov 9 at 9:01
Jasu
558
edited Nov 9 at 9:08
asked Nov 9 at 9:01
Jasu
558
asked Nov 9 at 9:01
Jasu
558
asked Nov 9 at 9:01
Jasu
558
558
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20
add a comment |
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53222615%2fselecting-data-from-excel-and-sending-an-email-in-uipath%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What have you tried so far? idownvotedbecau.se/noattempt
– Wolfgang Radl
Nov 9 at 18:08
Managed to write the selected data to another Excel file using: Get Row Item, Add Data Row, Write Range and Build Data Table. But still struggling how to send the attachments to their corresponding users by emails.
– Jasu
Nov 9 at 20:09
You might want to update your original question to reflect that. Also, look into the Split() method for strings. You can just use it in any assign activity (docs.microsoft.com/en-us/dotnet/api/…).
– Wolfgang Radl
Nov 9 at 20:20