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
True
False
False
False
True
False
False
True
False
False
False
True
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
True
False
False
False
True
False
False
True
False
False
True
10,4.5
200,51
False
330,2.5
60,75
860
360,77.5 360,94.5