How to send selected column of a table through email?

Help
1

hi, i am a beginner in uipath. i have a table containing end dates. i have to identify dates which has exceeded more than 60 days and send an email as a reminder. i have completed identifying dates which has exceeded more than 60 days, i am trying to figure out how to send that identified dates together with its whole row through email(outlook or smtp)? here is the sample of the table? sample .xlsx (11.6 KB)

2
  1. Use Excel Application Score then Read Range activity to read the whole Excel file into a Data Table
  2. Use For Each Row activity to loop through it
  3. Compare your date in an if statement, if it passes your condition then
  4. For example, create new Excel table, or convert your row to a string
  5. Use Send Email activities to send the row
3

hi sir thanks for your response. i have completed identifying the dates which has exceeded 60 days, i am trying to figure out how to use the send email activity to send that identified date together with its whole row.

4

How do you check for the date if exceeded?

Like this?

CINT((DateTime.Now - Datetime.ParseExact(row("Start Date ").ToString,“MM/dd/yyyy hh:mm:ss”, System.Globalization.CultureInfo.InvariantCulture)).TotalDays)

5

Can you send a link on how to learn more about this syntax writing
Thanks in advance

6

CompareDates.xaml (7.3 KB)

Try something like this

7

Sure

In this expression i use CINT to round off the number.
DateTime.Now to get the current Date
and
DateTIme.ParseExtract(row("Start Date ").ToString,"MM/dd/yyyy hh:mm:ss, System.Globalization.CultureInfo.InvariantCulture) to parse the value of the Row(“Start Date”) to a date time.

After that i used TotalDays to get the Date difference between two days.

I really don’t know every method myself but i google alot. Hope it helps

2 Likes
8

thank you. but while the date comparison works…the email automation does not seem to work. the whole row of the date which has exceeded 60 days has to be sent through email.

9

Untitled

This is how my mail looks like

10

hello, actually I have problem to assign a specific column to send the email. The column only contains messages. So, what variable I need to assign?

i’m not sure about this error.

image
image1458Ă—1009 51 KB

11

I used String.join(“,”,Row.itemArray) to get whole row

12

image
image747Ă—346 5.9 KB

its turned out to be like this

13

Don’t know what you are doing, the expression is to turn DataRow to a String.

14

EXAMPLE.xaml (23.2 KB)

  1. i tried to read the column from multiple spreadsheet.
  2. After that, from this spreadsheet, i want to send the email with a column (email)

Problem:
My uipath cant read the content of the cell.

15

Can you share the xlsx file?

17

If i understood correctly, you want to read email from “Maintenance” sheet, and send the body?

18
  1. From Maintenance sheet,
  2. Have a column (Body)
  3. From this Body, I want to send to multiple recipients that’s why I build a data table. Actually, i want to fill up with multiple recepients.