Sending outlook mail with a specific format of body

Help
1

Hey,

I want to send mail to multiple emails which is in excel file and in body i want to write a specific format of message which is in notepad document. Now each row of excel has different information first i want to send such info in notepad to change some data in excel and then i want to send mail. I want to do for every row which have different information.
Can anyone help me in this?

2

Hi @Mudita123,

I have attached a sample containing simple html template containing text within ‘<<>>’ whic i will read in UiPath and replace and then insert in mail and send email.

See if it fits you question, or revert back if you need clarification.

Solution.zip (17.3 KB)

3

Actually i has notepad file and there are 4 places where i want to do changes. when i try with two places in assign activity with replace method only then it works but i tried with 4 it doesn’t work.

4

@Mudita123,

There may be 2 case in which this can happen,

  1. Your text is not found in read string to replace.
  2. Your first replace string changes the string that needs to be replaced next.

try replacing one by one and put write line and observe the changes. This will help you solve and know why string is not getting replaced.

5

its done
Thanks for reply and help.

6

Hey
i want to get confirmation message in excel that email is sent.
How to do that?

7

Get all emails in sent items and check if your email is there.

8

Ok
I just want to ask one more thing that in notepad file i have bullets in few lines.
When i send the notepad file content as body message in mail that time in mail it is not showing the bullets.

9

Try using html instead of notepad, in notepad bullets are not supported.

10

Yeah its done.
Thanks!!

11

Kindly close the topic

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.