Find Course In column and add 1 to current booking

Help
, ,
1

excel

For this problem, I get an email saying an individual is doing a course so I use that course name and then I would like to add 1 to the current booking. How do I go about this?

2

Hi
will the course name mentioned in subject or the body of the mail
If its from subject then
–first get the list of mails from GET OUTLOOK MAIL ACTIVITY or any mail activity with a variable named list_mails
–use a EXCEL APPLICATION SCOPE and pass the file path of excel as input and inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
–now use a FOR EACH activity and mention the above obtained variable as input and change the type argument as System.Net.Mail.Mailmessage in the property panel of FOR EACH activity
–inside this FOR EACH loop use a FOR EACH ROW activity and pass dt as input
–now inside this FOR EACH ROW activity use a IF CONDITION like this
item.Subject.ToString.Contains(row(0).ToString)
if true it will go to THEN Part where we can use a assign activity like this
row(1) = (Convert.ToInt32(row(1).ToString)+1).ToString
and next to this assign activity within THEN part use a BREAK activity

similarly for body of the mail

@Stabbathehut

3

So I already have passed the mail body string as a variable. Do I pass for each row in dt.rows? Slightly unclear with where to go sorry.

image
image1920×1048 145 KB