Hi guys,
@sarathi125
@Palaniyappan
@HareeshMR
Need help in below scenario.
Received table in mail body pick values row wise and enter values into web application.
refer below Image.
1 Like
Check this -
1 Like
If you are getting it in a html formatted mail, then you can do the following steps to extract data without issues.
- Open the Email and save that as .mhtml format.
- Then open that .mhtml file using any browser which is compatible for your process.
- Then do web data scraping of that table from the web page, so now you will get the data as a datatable without parsing the html body.
- Now you can feed the data into the webpage.
You also can try with html body parsing process, but you need to handle null values with this step, sometime if the table cell does not contains values then you have to check and make that.
If you have any questions please let me know.
3 Likes
Hello,
Use unvoke VB Code and follow the link : How to read table pasted in outlook message body using vba? - Stack Overflow to read table in outlook.
Easy and fast
Cheers & Thanks
Vj
1 Like
What is the data type of check variable?
1 Like
Hey @sarathi125
is there any other way like reading column name in data table loop. ??
because save html file, open file,read that file instead better to get excel file from client.
so, I am thinking if it is possible to simple read data column name in same loop fill into web application.
is it possible ?
I didnât get this buddy kindly come again
Cheers @prashantP
in HTML Text field in the properties type this : âitem.Headers(âHTMLBodyâ).ToStringâ, please type it as copy paste didnât work for me. That should be it, once the activity works you will get all the tables inside that mail as separate excel files.
this is where you will get to know how many tables are there in foreground & background for that mail. If there are unwanted tables in the background which are getting extracted you need to correct the template of email from the sender of it. And if that is done you will have your desired table from email body as an excel file with which you can play further.
1 Like
I am working on POC to one of our client.
Using data table loop(excel) we can easily enter data into web application with same loop.
below is reference file.
instead of doing this â Read table values row wise form email body - #3 by sarathi125
is it possible to read body content similar to entering data from excel file ?
Letâs say Loop [ store first value 101 second 000041, next to enter copied value in web application ] next it will start reading from second row.
something like this.!
Hope you understand.!
then you need to iterate row by row or cell by cell the way it is done normally with excel, inside excel scope add read range/cell activity and then take for each row iterate it using a counter if needed and assign the values to variable.
1 Like
Regarding my last previous topic as I mentioned below
I am trying to execute this process from robot tray(from studio robot and attended robot) but it fails to save attachments and getting below message
and below process I have done for download attachments
Please suggest ASAP. I have to give demo today with client.
Thanks.
Kindly in run debug mode once like which activity is throwing this error
Cheers @prashantP
@Palaniyappan
by doing debug now it is working on Development Robot but not from attended robot.getting Time out error .
Please suggest
1 Like
Like at which activity we are getting timeout
If itâs from get outlook mail activity
Kindly ensure once whether outlook is configured to your machines or not
Cheers @prashantP
getting below error after entering user id before enter password
i have used get password activity and passed variable to type into activity
Thanks,
parvathi_ayanala
jamiejam
Anirudh_Tugawe