Ill use Get Outlook Mail Message and get a variable (mailList)
Now i want to sort out the emails with certain words in the Subject line and in the Mailbody
the word inte the subject line is “SEABN” and it will always be in the subject line.
The words i look for in the mail body is “UPDATE” (thats the header) and then “Added Individuals” and/or “Deleted Individuals”
i have tried this:
(?<=UPDATE\s)\w*
And that worked to get the first word after/under the Header (UPDATE) But how do i get the word in the second row under the header.
The mail body looks like this: And its always looks like this.
Dear colleagues,
Please find the updated ABN attached.
UPDATE
Added individual. SER#7-9 added to ABN
The rules for the body text:
Action implemented = Added individual. AND Information altered = SER#7-9 added to ABN.
eg: Added individual. SER#7-9 added to ABN. Action implemented and Information altered are always separated by a dot/period.
Actions can be some of these:
• Added individual
• Deleted individual (Not Departed)
• Reason for Deletion
• Change in International Travel Itinerary
• Change in Domestic Itinerary
• Change in Escort Information
Action implemented = Added individual. AND Information altered = SER#7-9 added to ABN.
eg: Added individual. SER#7-9 added to ABN. Action implemented and Information altered are always separated by a dot/period.
Actions can be some of these:
UPDATE
Added individual
Deleted individual (Not Departed)
Reason for Deletion
Change in International Travel Itinerary
Change in Domestic Itinerary
Change in Escort Information
all of these actions will not appear at the same time. But perhaps 2-3 of them.
Output is something i can use to write in the excelfile that ill pass on to the Performer.
either if the information is written in another excelfile (Because the excelfile for the performer is not made yet in my process) were i can transfer it.
Or in a datatable or array of string.
im not sure which is the best here.