How to solve such scenario?

Help Studio
, ,
1

email_basket = # list of eligible vdm emails
vsl_basket = # unique (no repeat) list
master_excel_sheet = # your records for every vessel
next_empty_row = 0 # track if row is filled for excel sheet

For every email in my inbox,
if it is VDM and date is D or D-1, then add this email to email_basket

For every email in email_basket,
get the email subject
get the vessel name
if the vessel name is not already inside vsl_basket, then add this vessel name to vsl_basket

For every vessel name in vsl_basket,
Access the latest email through email_basket.
Scrap data from the latest email.
Add data to master_excel_sheet starting with row = next_empty_row

2

Hey @xiangyun.koh

The above statement can be implemented by the activities from Outlook and Excel Activities provided by UiPath.

Check the above official documentations from UiPath to get a overview of activities provided in both packages.

You need to combine the traditional loops and the activities from above packages in orded to create a solution for your problem statement.

Thanks,
Gautham.