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.
(if column name or id knows, use that instead of ‘@’ )