Noob here, using Stuidio-x Community edition for Windows. I’m trying to create an automation that creates individualized emails within a web browser and populates each To line with a different email address currently saved in an Excel list. (I don’t have access to the SMTP address.)
Question 1: I assume I need to build a For loop to compose each email. But which specific Action should I use? I see a For Each Email action, but I think that acts on existing email messages only, not new ones. Do I need to use the Web Recorder for this?
Question 2: I think I need a separate For loop, such as Excel For Each Row, nested inside the first to get each email address from the list and print it into the To line, right? If so, I assume I need to save the column of addresses as a “Resource” in my Data Manager, but how do I do that? I don’t see an option to select that column and “save for later”. Alternatively, I’ve tried using a Project Notebook instead of my own Excel file, but when I try to select my column of interest, it only lets me indicate a single value. How can I tell uipath to read/store the whole column as a variable for later use?
So, I’m not trying to read data from my emails, I’m trying to compose emails. I’ve already successfully composed a single email by writing a single Excel value into the To line. The issue is how to repeat that cycle. Should I be able to do that using the Excel For Each Row action?