System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup UiPath.Database System.Text.RegularExpressions System.Activities Microsoft.VisualBasic mscorlib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities System.ValueTuple UiPath.Excel UiPath.Mail UiPath.CV System.ServiceModel UiPath.Database UiPath.System.Activities.Design True [strQuery2] ["DELETE * from EmailAutoMation"] True [strUsername] [Regex.Replace(Regex.Replace(System.Text.RegularExpressions.Regex.Match(item.body.ToString,"(?<=User corp IDs [(]semicolon separated[)]:)[\s\S]*").ToString, "\n.*", "").ToString,"\s","").tostring] [strapprover] [Regex.Replace(Regex.Replace(System.Text.RegularExpressions.Regex.Match(item.body.ToString,"(?<=New approver corp ID:)[\s\S]*").ToString, "\n.*", "").ToString,"\s","").tostring] [strCostcenter] [Regex.Replace(Regex.Replace(System.Text.RegularExpressions.Regex.Match(item.body.ToString,"(?<=Choose new costcenter:)[\s\S]*").ToString, "\n.*", “”).ToString,"\s","").tostring] True [strQuery] ["insert into EmailAutoMation (UserName,Approver,CostCenter) values("+"'"+strUsername+"'"+","+"'"+strapprover+"'"+","+"'"+strCostcenter+"'"+");"] [strQuery3] ["insert into EmailAutoMation (UserName,Approver,CostCenter) values("+"'"+strUsername+"'"+","+"'"+strapprover+"'"+"'"+strapprover+"'"+");"]