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 System.Xml.Serialization System.Collections.ObjectModel System.Runtime.Serialization System.Reflection System.Runtime.InteropServices System.ComponentModel UiPath.Excel System.Activities.DynamicUpdate UiPath.Excel.Activities UiPath.Mail.Outlook.Activities UiPath.Mail.Activities System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities System.Data.DataSetExtensions System.ValueTuple System.ServiceModel System.Memory System.ComponentModel.Composition System.Runtime.Serialization UiPath.Excel.Activities UiPath.Excel UiPath.Mail.Activities True False True True False 270,2.5 60,75 300,77.5 300,167 __ReferenceID0 200,167 200,66 False False [Projectpath] [Environment.CurrentDirectory] True [LinemanagerName] [row.Item("LineManager Name").ToString] [LinemanagerEmailID] [row.Item("LineManager EmailID").ToString] [InvoiceNO] [row.Item("Invoice No").ToString] [Amount] [row.Item("Final Amount").ToString] [FinalAmount] [Cdbl(math.Round(Cdbl(Amount),2))] True True False [CurrentYear] [System.DateTime.Now.Year.ToString.Substring(2,2).ToString] [CurrentMonth] [DateTime.Now.AddMonths(-1).ToString(“MMM”)] [mailSubject] [CurrentMonth+"'"+CurrentYear+" - ANZ SSI Inv # "+InvoiceNo.ToString+" / Manager Name :"+lineManagerName.ToString] [mailBody] ["<HTML>Time: "+Today.ToShortDateString+ ","+DateTime.Now.ToLongTimeString() + "<br>"+ "<p>Please find the enclosed digital invoice copy as per details below. Pls write to in case any further info or details are required.</p>"+ "<br>"+ "<table border='1'>"+ "<tr><th>Line Manager Name</th><th>Manager Emailid</th><th>Invoice No.</th><th>Total </th></tr>"+ "<tr><td>"+LinemanagerName.ToString+"</td><td>"+LinemanagerEmailID.ToString+"</td><td>"+InvoiceNO.ToString+"</td><td>"+Amount.ToString+"</td></tr>"+ "</table>"+ "<br>"+ "<br>"+ "<br>"+ "<p>Regards</p>"+ "<p> Invoicing Team</p>"+ "</HTML>"] [invoiceAttachmentPath] [InvoiceAttachemntsPath+InvoiceNo+".pdf"] True False False False True False False [Addfailuredatarow] [dtFailureEmpData.NewRow] [Addfailuredatarow(0)] [InvoiceNO] [Addfailuredatarow(1)] [LinemanagerName] [Addfailuredatarow(2)] [LinemanagerEmailID] [Addfailuredatarow(3)] [Amount] True False False False False False [ExceptionMessgae] [exception.Message]