I have an excel database tracker on which multiple users enter “Order Confirmed” Date on a real time basis. At the end of the day, the bot (Confirm2PI - MainOrder2ShipQuestion.xaml (32.9 KB) ) Daily File.xlsx (11.2 KB) Main.xaml (8.5 KB) will check the file and wherever the Order Date is the same as today, it will mark a “Yes” in column G “Billing Details Requested”. After this it will send an email to the respective POC with subject “Client Name” “Equipment Ordered” Attention “POC First Name” Billing Details Requested, append an excel attachment and write a template message and send the email.
I am able to build the end to end bot if I want to do this just for one row. However, I am stuck when I want to build this for multiple rows (let us say Rows 3 to 10)
I have attached the excel file and the bot for multiple rows so far. Why am I not getting a “Yes” in column G even when the Order Date is today. I tried checking the format in which date shows - i.e 11/15/2019 using a message box and using that format in Row 5 and 6 but it still returns a No. What am I doing wrong.
If I want emails to be sent to every with the subject relevant to that client - how do I build that? Should I be using “Read Range” for each column and storing output in variables and the using the variable names to specify the subject line? As a reference I have also attached the bot that I did for a single row (Order2Ship). Please bear with me - these are the very first bots that I have built.