Text Outlook Mail in Config and put variables inside

[Franciszek_Milczarsk (Franciszek Milczarski)]

Hi!

I have the e-mail body/subject content in config file (not in HTML format).

I would also like to put there information about the start or end time of the robot.
These values are assigned during the process.

Is there any other way to add value to the body/subject text (in this situation) than using the replace function?

Best wishes,
F.

[Lahiru.Fernando]

Hi @Franciszek_Milczarsk

Yes… You can do that… Refer to my answers to the below thread which I used the String.Format option…
It will help you get your task done.

Sending unique emails

Hello @sam1313 Yes you can do this… Follow the below steps. First have the body of the email saved in a text file. Make sure the body of the email text should be included with html tags. Example shown below… For the point you need to enter the dynamic value, include the part {0} so that it will be replaced later. If you have multiple values to join in, it should go as {0} {1} {2} and so on… see the image below for better understanding… Now read the text file using read text file activity int…

[ranjith_udayakumar]

I always prefer to keep the body of the mail in Database as a string. Dont keep it in config instead you can keep it as a separate text file.

And coming to your question. Pre-format the text with dummy variables and replace it with the variables before sending mail.

For instance:

body.txt

Start Time: vStartTime
No of Records Processed: vNoOfRecordsProcessed
End Time: vEndTime

Read the text file and store it as strBody

Then Replace the actual variables like the following.

strBody = strBody.Replace("vStartTime", strStartTime).Replace("vNoOfRecordsProcessed", strNoOfRecordsProcessed).Replace("vEndTime", strEndTime)

Then use the variable in mail

Hope it helps…