I want to read the excel attached in the mail with particular message id.
i have retrieved the message id as mailmsg.Headers(“UID”) and store it in an excel.
now i want to go through each message id one by one, go to outlook and validate the excel which is present in the mail as an attachment.
Use get outlook mail messages activity and store it in a mail message use for each item for mail message and set a condition as item.ToString.contains(“uid”)
Then read the Excel and inside for each row set Condition as row (“column name”). toString.contains(item.tostring)