How to send email containing extracted data into body of paragraph


the “dooo” variable is my extracted total amount from a column in an excel sheet. Cant put it in the body of the paragraph how do i solve this?

HI @julian_ho

Say your body is stored in a string str

str = "Hi blah blah <Placeholder> blah blah"

Use str.Replace("<Placeholder>",doo.ToString)

cheers

where do i put this into?

Hi @julian_ho

Is there a constant body that you will be using?

in that body storing add a Placeholder and replace it when needed before sending it

You will use in assign

str = str.Replace("<Placeholder>",doo.ToString)

str is the variable in which the body is stored

cheers

yes just need to send that one body. whats a placeholder may i ask?

@julian_ho

Check this

Input:
image

InCode:

Output:
image

hope this helps

cheers


i cant upload my csv file ?

@julian_ho

there is no extension you provided … See the path…what did you provide in the input?

cheers


im trying to attach this csv file to the attachments section of send email exchange message activity.

Hi @julian_ho

please give path with .csv extension

cheers


now this happened… i only have uipath running on the com
could it be that i have a previous activity that is extracting the data from the same excel sheet and summing a column up?

@julian_ho

CSV file is open please close it

the excel sheet is closed tho

Hi @julian_ho

Open task manager and see if any excel process is there close it


what does this mean ?

Hi @julian_ho

You need to use ‘send outlook mail message’ or ‘Send mail’ activities if you are using outlook …else you need to provide exchange server details

cheers

@julian_ho

Can you please close this topic with the solution so that it helps people with similar problem of modifying the mail body

Cheers