Email Automation - Outlook

Hi Team,

I am trying to use a template and modify (Replace some text based on a criteria) and send that email.

Do we have any activity which can do in App integration outlook or I should use Word activities, copy file, replace text and then use the output for sending email.

Please let me know if you have a better way of doing this.

Thank You
Arun Daram

Where do you have this template?

Can you read get that into a string variable and do string.Replace and add it to email body?

1 Like

Hi vvaidya,

I have a template on a sharepoint site, pulled it in local drive. Also, I need to delete/replace multiple words/sentences based on the criteria

Thank You

Then as you said

Download File > Copy File > Replace Text >Read Text> Add to Outlook body

Works well.

hi @vvaidya how to Add to outlook body???

i want to replace the body of outlook email with data from excel.

i have tried using replace function but it doesnt work also how to change string to mail object??

when i am checking with the messagebox it shows that the email body has been replaced but after that step when i am moving that item to other folder it shows the old messagebody and not the replaced one how can i achieve that??


The only thing missing would be formatting - it just does text, any idea how to get formatting from word doc to email body?

I tried saving word to htm and other formats but not luck.

Any help is appreciated.

Thank you!


did you get a solution yet? I have an excel template, which would have dynamic rows. output.xlsx (8.5 KB)

How can i copy the exact in Outlook?