Create Text from Excel info

Help Studio
3

Hi @jack-keenan-clancy welcome to forum

For this

  1. First create a text file with following text

Hello Name

Your meeting time is at Time

Thank you

  1. Read the excel field and store in dt1

  2. Use for each row to loop through each rows of dt1

Inside it use the following

  1. Read the text file and store in stringvariable body

use Assign activitiy to assign body varible with values of each rows from excel

body = body.Replace(“Name”, row(0).ToString). Replace (“Time”, row(1).ToString)

Then after this use mail activity like Outlook mail message activitiy or smtp to send an email with email to whom u want to.send as row(2).ToString

Hope it helps you

Regards

Nived N

Happy Automation :relaxed::relaxed::relaxed:

1 Like