System.Activities.XamlIntegration System.Activities.Validation System.Activities System.Activities.Statements System.Activities.Expressions Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections.Generic System.Data System.Diagnostics System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq System.Windows.Markup System.Drawing UiPath.Core UiPath.Core.Activities System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml System.ServiceModel System.ComponentModel.Composition System.Drawing UiPath.UiAutomation.Activities UiPath.System.Activities System.ValueTuple UiPath.Excel UiPath.Mail UiPath.Studio.Plugin.Workflow [Projectpath] [Environment.CurrentDirectory] [DeliverToDate] [row.Item(0).ToString] [DeliveryDate] [DateTime.ParseExact(DeliverToDate,“dd MM yyyy”, System.Globalization.CultureInfo.InvariantCulture)] [ReferenceCode] [row.Item(3).ToString] [DONo] [row.Item(4).ToString] [InvNo] [row.Item(5).ToString] [CustomerName] [row.Item(6).ToString] [WHEmail] [row.Item(7).ToString] [SalesEmail] [row.Item(8).ToString] [DeliveryType] [row.Item(9).ToString] [CurrentYear] [System.DateTime.Now.Year.ToString.Substring(2,2).ToString] [CurrentMonth] [DateTime.Now.AddMonths(-1).ToString(“MMM”)] [mailSubject] ["[BCP]" + ReferenceCode + " " + ":" + DeliveryType + "To" + " " + CustomerName + "- ETA" + " " + DeliverToDate] [mailBody] ["<HTML>Time: "+Today.ToShortDateString+ ","+DateTime.Now.ToLongTimeString() + "<br>"+ "<p>Kindly refer "+ DeliveryType + "arrangement as per below:-</p>"+ "<br>"+ "<p>DI No: "+ ReferenceCode +"</p>"+ "<br>"+ "<p>Inv No: <b>"+ InvNo +"</b></p>"+ "<br>"+ "<p>DO No: <b>"+ DONo +"</b></p>"+ "<br>"+ "<p>Delivery To: <b>"+ CustomerName +"</b></p>"+ "<br>"+ "<p>ETA Date: <b><u>"+ DeliverToDate +"</b></u></p>"+ "<br>"+ "<p>Kindly arrange delivery accordingly and confirm arrangement by return</p>"+ "<br>"+ "<p>Please send us acknowledge DO once available for our record</p>"+ "<br>"+ "<p>Thank you</p>"+ "<br>"+ "<p>Regards</p>"+ "<br>"+ "<p>TTMSB BA Team</p>"+ "</HTML>"] [SupportingDocsPath] [directory.GetFiles("C:\Users\eelin\Documents\UiPath\DailyDelivery\Data\Input\Supporting","*.PDF")] [SupportingDocsPath] [SupportingDocPath+".pdf"] [SupportingDocsPath.ToString] [mailBody] ["<HTML>Time: "+Today.ToShortDateString+ ","+DateTime.Now.ToLongTimeString() + "<br>"+ "<p>Kindly refer "+ DeliveryType + "arrangement as per below:-</p>"+ "<br>"+ "<p>DI No: "+ ReferenceCode +"</p>"+ "<br>"+ "<p>DO No: <b>"+ DONo +"</b></p>"+ "<br>"+ "<p>Delivery To: <b>"+ CustomerName +"</b></p>"+ "<br>"+ "<p>ETA Date: <b><u>"+ DeliverToDate +"</b></u></p>"+ "<br>"+ "<p>Kindly arrange delivery accordingly and confirm arrangement by return</p>"+ "<br>"+ "<p>Please send us acknowledge DO once available for our record</p>"+ "<br>"+ "<p>Thank you</p>"+ "<br>"+ "<p>Regards</p>"+ "<br>"+ "<p>TTMSB BA Team</p>"+ "</HTML>"] [SupportingDocsPath] [directory.GetFiles("C:\Users\eelin\Documents\UiPath\DailyDelivery\Data\Input\Supporting","*.PDF")] [SupportingDocsPath] [SupportingDocPath+".pdf"] [SupportingDocsPath.ToString] [Projectpath] [Environment.CurrentDirectory] [DeliverToDate] [row.Item(0).ToString] [DeliveryDate] [DateTime.ParseExact(DeliverToDate,“dd MM yyyy”, System.Globalization.CultureInfo.InvariantCulture)] [ReferenceCode] [row.Item(3).ToString] [DONo] [row.Item(4).ToString] [InvNo] [row.Item(5).ToString] [CustomerName] [row.Item(6).ToString] [WHEmail] [row.Item(7).ToString] [SalesEmail] [row.Item(8).ToString] [DeliveryType] [row.Item(9).ToString] [CurrentYear] [System.DateTime.Now.Year.ToString.Substring(2,2).ToString] [CurrentMonth] [DateTime.Now.AddMonths(-1).ToString(“MMM”)] [mailSubject] ["[BCP]" + ReferenceCode + " " + ":" + DeliveryType + "To" + " " + CustomerName + "- ETA" + " " + DeliverToDate] [mailBody] ["<HTML>Time: "+Today.ToShortDateString+ ","+DateTime.Now.ToLongTimeString() + "<br>"+ "<p>Kindly refer "+ DeliveryType + "arrangement as per below:-</p>"+ "<br>"+ "<p>DI No: "+ ReferenceCode +"</p>"+ "<br>"+ "<p>Inv No: <b>"+ InvNo +"</b></p>"+ "<br>"+ "<p>DO No: <b>"+ DONo +"</b></p>"+ "<br>"+ "<p>Delivery To: <b>"+ CustomerName +"</b></p>"+ "<br>"+ "<p>ETA Date: <b><u>"+ DeliverToDate +"</b></u></p>"+ "<br>"+ "<p>Kindly arrange delivery accordingly and confirm arrangement by return</p>"+ "<br>"+ "<p>Please send us acknowledge DO once available for our record</p>"+ "<br>"+ "<p>Thank you</p>"+ "<br>"+ "<p>Regards</p>"+ "<br>"+ "<p>TTMSB BA Team</p>"+ "</HTML>"] [SupportingDocsPath] [directory.GetFiles("C:\Users\eelin\Documents\UiPath\DailyDelivery\Data\Input\Supporting","*.PDF")] [SupportingDocsPath] [SupportingDocPath+".pdf"] [SupportingDocsPath.ToString] __ReferenceID0 __ReferenceID1 dzlDOlxVc2Vyc1xlZWxpblxEb2N1bWVudHNcVWlQYXRoXERhaWx5bW9uaXRvcmluZ1xNYWluLnhhbWxkQAPNBA8CAQFDNENtAgEDRDRETQIBAlYJYBQCAXFjDfMCGAIBBFcLXhQCAXlfC1/uAQIBcmQP8gIfAgEFXDZcVAIBfFk3WUQCAXpfRl9RAgF3X7YBX7sBAgF2X8kBX+sBAgFzZEBkSwIBb2oV7wIgAgEGaxdyIAIBa3MXc4MBAgFpdBeBAScCAWiCAReJASACAWSKAReKAYMBAgFiiwEXkgEgAgFekwEXkwF6AgFclAEXmwEgAgFYnAEXnAF7AgFWnQEXpAEgAgFSpQEXpQGCAQIBUKYBF60BIAIBTK4BF64BfQIBSq8BF7YBIAIBRrcBF7cBgAECAUS4ARe/ASACAUDAARfAAYIBAgE+wQEXyAEgAgE6yQEX0AEgAgE20QEX2AEgAgEu2QEX7gIgAgEHcElwXwIBbm1KbVkCAWxzb3OAAQIBaocBSYcBXwIBZ4QBSoQBWQIBZYoBb4oBgAECAWOQAUmQAV8CAWGNAUqNAVACAV+TAW+TAXcCAV2ZAUmZAV8CAVuWAUqWAVECAVmcAW+cAXgCAVeiAUmiAV8CAVWfAUqfAVgCAVOlAW+lAX8CAVGrAUmrAV8CAU+oAUqoAVMCAU2uAW+uAXoCAUu0AUm0AV8CAUmxAUqxAVYCAUe3AW+3AX0CAUW9AUm9AV8CAUO6AUq6AVgCAUHAAW/AAX8CAT/GAUnGAYQBAgE9wwFKwwFXAgE7zgFJzgF1AgE5ywFKywFYAgE31gFJ1gG5AQIBMdMBStMBVwIBL9kBWtkBagIBCOABGacCJAIBHqgCGe0CJAIBDtsBG94BJgIBCeEBG/8BJAIBKoACG4ACggECASiBAhuHAiYCASCIAhumAisCAR+pAhvFAiQCARrGAhvGAoIBAgEYxwIbzQImAgEQzgIb7AIrAgEP3AEd3AGIAQIBDN0BHd0BkgECAQrjAU7jAVgCASuAAnOAAn8CASmCAh2GAjICASGrAk6rAlgCARvGAnPGAn8CARnIAh3MAjICARHcAXXcAYUBAgEN3QF13QGPAQIBC4IC7AOCAvcDAgEnggJ0ggKQAQIBJoICwwKCAtECAgElggKnAYICrQICASSCArMCggK/AgIBI4IC2QOCAugDAgEiyALsA8gC9wMCARfIAnTIApABAgEWyALDAsgC0QICARXIAqcByAKtAgIBFMgCswLIAr8CAgETyALZA8gC6AMCARI= False False True False False False False True False False False True False False False False True False False False True False False False False True False True False False 260,164.5 200,51 260,94.5 200,51 360,145.5 360,164.5 False False True False False True False False False True False False False False True False False True 10,4.5 200,51 False 330,2.5 60,75 860 360,77.5 360,94.5