How to create email and insert fields from spreadsheet

Hi everyone!

I am trying to use UiPath to send letters to employees to inform them of their bonus amount.

I have a database of 30 rows of names and bonus amount.

I also have a simple word document that says “Hi xxx , you will be receiving <$yyy>.”

May I ask how should I script the process?

Many thanks.

@kai_jnr If you have to read the data from a Database, use UiPath.Datatabase.Activities, After that it’s just Iterating the Data and Replacing name and Amount.
But make sure you get the Data in a Datatable using Database Activities.

1 Like

@kai_jnr.I am attaching the work flow ,instead of retrieving the items form data base,i used spread sheet (25.2 KB) .