Copy an email address from an Excel/CSV file and copy it to the recipient field

  • 19 January 2023
  • 1 reply



I am a student and I am building an RPA to connect to an ERP and export an Excel/CSV file with customers with back orders.

I will then email everyone on this file, but I am stuck at this stage.

My steps are: 

1- open the file "Orders.csv".

2- look for the character "@" save in a variable "EmailGet".

3- put the "EmailGet" variable in the recipient field of the next task, "send email". 

What am I missing? Can you help me, please? 

Thank you in advance.

Gilberto Parente



1 reply

Userlevel 5
Badge +14

@gilbertoparente you can create a list and copy all email ids and use that list for receipient

(if column name or id knows, use that instead of ‘@’ )