Create a Loop of excel to outlook actions until no more rows in listing

Hi -

Goal: Create a bot that takes an excel listing of excel formula values (event title, Date, cell, e-mail) and create a loop to generate individual outlook meeting invites for each row (a roster of birthdays).

I’m struggling how to create a list of variables that will continue to re-define themselves for each row. anyone have any suggestions/advice? want to use tab RPA Data Clean to pull the data from what an end user puts on tab roster in excel.

Team Roster with Birthdays.xlsx (32.7 KB)

1 Like

Hi @rangeletti3 you need to copy the excel data in a Table and use For Each loop to iterate through it.

Check out example with Outlook. Looks like it does exactly what you need, except it creates a message instead of an invite.

1 Like