I need to get an information from a spreadsheet and put in the TO of activity send outlook email, can anyone help me?
All you have to do is to use the activity Read Range to read everything that you want from that spreadsheet or if you want from a specific cell, then you can use Read Cell activity. Step 2 will be, if you use Read range that one will return you a DT, so you will need to iterate to each row that you have in this data table and with row(“Column header”) you will take all you need and add in the send outlook email activity to the TO field.
If you use the Read Cell, then the output will be a variable where it will be store what do you want to add in TO field.
That was it, thank you very much.