First time poster, only have been using UiPath for about 3 months.
I have figured out about 90% of my issue. I have figured out how to get the Outlook event and forward the Outlook event, but it only works if I put a single email address in the attendee field. If I try to use an email list from excel, Excel resources don’t show the worksheet I’m using, so I can’t do it that way and I have tried creating a variable, like in marketplace_/listings/extract-email-ids-from-excel-and-send-mail, but the attendees field doesn’t like that. This template from the marketplace works with my Excel file and everything pointed to the right list. This template also allows me to select the actual column from the Excel resources.
Can someone please help me understand what I’m missing that I can’t forward my event to the email list in my Excel worksheet?
@Sesasha
Welcome to the UiPath community.
What you’d like to do is to read the recipient from the Excel then put it into the Outlook attendee field, right?
For the Excel part, assuming you put the string ‘aaa@abc.com; bbb@abc.com’ (separated by semicolon) at cell A2. Use ‘Read cell’ should not be a problem.
Please attached your current workflow removing sensitive info for further checking.
You can use read range activity to read the data that contains the recipients.
After that, read range activity gives you the output as a datatable.
Then you can split the data however you like, cast it as a List variable and use it in Send Outlook Mail Message Activity.
Removing the parenthesis doesn’t help either. I thought the issue might be like it had been with getting the event list, which is why I was hoping there was a parameter I could put in the parenthesis that would make it read correctly. It seems I was wrong.
