I have a program that sends out reminder based on an input file. Attached working version.
However, I would like to improve it by using get outlook mail to filer the email with “subject” and a “body”. The body has a text label “email”, not the From field. Then compare the excel email column with the mail messages and send a reminder.
you have to use Get Outlook Mail Messages or Get Exchange Mail Messages activity. Both as output returns list of mail messages. You can iterate through this list using for each, please use System.Net.Mail.MailMessage as TypeArgument for for each. You can view body using it’s property ‘.Body’, specified text in body can be found using regex (import System.Text.RegularExpressions namespace). Example: Sequence2.xaml (8.1 KB)
It’s an email that has text as attached. And the body text has Email label and the value contains and email address. This is so we could use it to compare with the excel input. Then for those who have yet to submit the form, to email reminder. Thanks !
It is not showing the expected results. Do you think we should use “not contain” instead of putting the send email activity in the ELSE condition.
Or should the excel be read first then loop thru the email messages ? Becos what we have now is for every email it will loop thru the excel again. So, the same person gets sent more than once for reminder. Thanks !
It is not showing the outcome. Sorry, the requirement is
(i) The excel file has a list of email.
(ii) And it is used to check against email messages for the body that contains the email address.
(iii) If there is no match, then the person in excel email address will be sent a reminder.
I have attached the pictures that show existing codes where it is reading email message; and for every message loop thru the excel to find a matching email address instead. Thanks.