Hello Manish, Thank you for a great video. This is so very helpful and very detailed explanation. I try this, and have error, when my values in excel sheet are formula based. The txt file takes the values as 0 for all the cells. If i replace the formula with static number, then it works fine. Can you please advise on how to read the values, when it has a formula in the cell. Appreciate your help !!
I would like to ask if our data is in date format in excel, how do we ensure that the date convert to string in text file is in dd/mm/yyyy and remove the timing (00:00:00) as my output is 4/5/2020 00:00:00 (mm/dd/yyyy hh:mm:ss) in the email table.
Hi Manish! is possible to do a video on how to use a For Each loop to add things to queue / sending emails within a folder which needs to go to specific people
Thank you so much for such a great video. I am a le to follow each step. The only issue I had is somehow the "thank you. RPaTEAM " is hoping it in the last cell of the table. Another question, is there a way to empty out the notepad file prior to each run ?
How do we make the headings of the created table also dynamic? So instead of EmpName etc hardcoded into the script, how to make it take the heading name from the excel sheet?
Hi Manish, Hope you are having a great day. Can you please make the video for read specific email. Like in my email box we have 10 emails from different senders but i want read a specific sender email and rest of the emails are unread. Thank you
Nice explanation 🙂 . I have a query , if we want to do this vice versa then how can we do that. Like If we want a table from email to excel, how can we do that.
Hi, this is great! But I'm getting an error in Append line as " option strict on disallows late binding." How can i overcome this, looking forward for assistance. Thank you!
Hi Manish, Can you please tell me if I want to copy all the available rows and columns of excel to mail body without providing column name in tag. Thanks, Pooja
Hi, could u just explain if we want to do this vice versa then how can we do that? Like If we want a table from email to excel, how can we do that. This question is already asked in above, please do help
Dear Sir, I have to read the orders sent from different customers through email (outlook email). Problem is all the order emails are not well formatted so that we can read it properly and build a data table. Different customer send email differently and no pattern founds. How can we achieve this in UIPath? Could you please help me on this? Thanks,
I have 5 upcoming days data in excel file ..I want to print data in mail body date wise..how to do this..??? If data is available for next day I want print those daga for that particular day in the mail body. And if data is not available for that day.i want Print None word under that particular date in the mail body
Yeah it's working but output in showing me like a 4 times of each row in email body. In excel I give four rows only but email is coming for 4 row in 4 times. How will I am clear this. Please help me @uipath RPA
Hey , Thanks for this, Am able to do it properly , I just want one more thing, that how can print specific rows from excel? It will be very helpful if u answer.. Thanks again man.😊
Learn - How to Write Excel Data in Outlook Email in UiPath?
Ok Manish...
hello bro, let me ask yoyu something, what the content at tabledata.txt?
Thanks! This was one of the best thought out examples and demos for UIPath that I have seen! Very helpful!
Brilliant article! Was precisely stuck in converting a DT to Email - now resolved. Thank you!
Hello Manish,
Thank you for a great video. This is so very helpful and very detailed explanation.
I try this, and have error, when my values in excel sheet are formula based. The txt file takes the values as 0 for all the cells. If i replace the formula with static number, then it works fine. Can you please advise on how to read the values, when it has a formula in the cell.
Appreciate your help !!
I would like to ask if our data is in date format in excel, how do we ensure that the date convert to string in text file is in dd/mm/yyyy and remove the timing (00:00:00) as my output is 4/5/2020 00:00:00 (mm/dd/yyyy hh:mm:ss) in the email table.
Hi Manish, can you give inputs on How to extract table from outlook to Excel?
Hi Manish! is possible to do a video on how to use a For Each loop to add things to queue / sending emails within a folder which needs to go to specific people
Excellent dude...I just finished my task with the help of this video..this exactly covered my requirement...thank you so much..
hey i just have a small doubt, can we add css styling , or add background colours to the table created ?
Hi Manish,
Hope you are doing great!
If possible could you please make a video on SAP automation in uipath?
Yes bro. I can but I don't have SAP
Hi Manish,
Well done. Can you make a video on how to get the table content from the body of the email?
Thank you so much for such a great video. I am a le to follow each step. The only issue I had is somehow the "thank you. RPaTEAM " is hoping it in the last cell of the table. Another question, is there a way to empty out the notepad file prior to each run ?
How did you configuerd the variables?
How do we make the headings of the created table also dynamic? So instead of EmpName etc hardcoded into the script, how to make it take the heading name from the excel sheet?
Hi Manish,
Hope you are having a great day.
Can you please make the video for read specific email. Like in my email box we have 10 emails from different senders but i want read a specific sender email and rest of the emails are unread.
Thank you
Thank you so much for suggestion! I will work on it.
Can we send the same on specific date automatically??
Nice explanation 🙂 . I have a query , if we want to do this vice versa then how can we do that. Like If we want a table from email to excel, how can we do that.
Exactly!
Hi Manish
I am not getting the list of table items in my output
just getting the heading only, pls help
I have 6 rows in excel sheet. but I got the 24 rows in table... I mean the same data written 4 times in table.can you hep me on this.
Hi,
Can you make a video on Regex and Matches.
Hi, this is great!
But I'm getting an error in Append line as
" option strict on disallows late binding."
How can i overcome this, looking forward for assistance. Thank you!
Hi Manish,
Can you please tell me if I want to copy all the available rows and columns of excel to mail body without providing column name in tag.
Thanks,
Pooja
Hai please do one video
In email body 1st row is send to Manish email only
And 2st row is send to respective emails
Please do it for that 🙏
ITs nice, but I would like to add specific columns from Excel like 1,2,3,6,7,9 into HTML Table and send an email, could u plz explain?
Hi, could u just explain if we want to do this vice versa then how can we do that?
Like If we want a table from email to excel, how can we do that.
This question is already asked in above, please do help
Dear Sir,
I have to read the orders sent from different customers through email (outlook email). Problem is all the order emails are not well formatted so that we can read it properly and build a data table. Different customer send email differently and no pattern founds.
How can we achieve this in UIPath?
Could you please help me on this?
Thanks,
I have 5 upcoming days data in excel file ..I want to print data in mail body date wise..how to do this..??? If data is available for next day I want print those daga for that particular day in the mail body. And if data is not available for that day.i want Print None word under that particular date in the mail body
You are genius !!! this is exactly what i am looking for !!!
Yeah it's working but output in showing me like a 4 times of each row in email body. In excel I give four rows only but email is coming for 4 row in 4 times. How will I am clear this. Please help me @uipath RPA
Amazing one as always sir😍
Thank you so much Hareesh! Keep your likes and comments coming!
@@UiPathRPA I always do it sir , I even share to my friends who are willing to learn RPA
Thank you!
Hey , Thanks for this, Am able to do it properly , I just want one more thing, that how can print specific rows from excel? It will be very helpful if u answer.. Thanks again man.😊
Thanks bro..
You're giving best knowledge to Uipath beginners...👍👍👍
Glad to hear that
Very well explained. thnx.
Glad it was helpful!
in ExcelDT how to config
Wow super 😍
Appreciate your work, I am able to send the excel file content in the email body.
Thank you! Great work.
You are the best!! Thank you for the explanation, helped me a lot!
Thank you so much!
nice and very practical. thx ! :)
Thank you so much!
Tnqq so much
At last u heard my request
Yes and Thank you!
thanks
He repeats the same thing 50 times 😓 he is driving me crazy