Hello Everyone, I’m a beginner and I’m trying to capture tabular data from an Outlook mail. The body of the mail looks like as shown below: [image] I have tried saving the body of the mail in excel file, but the format is getting lost every time when the body of the mail is dumped in the excel fi…

There was another solution in the same link… i am posting the link for it below. Did u try that? Just copying the whole thing and pasting it to an excel? I tried this once when i wanted to extract a table from a word and put it into excel in the same way without any changes. I did a recording where …

Hi, Check the below link. [image] How to write email body table to excel file Help Hi, I am trying to extract table content from email body to excel file… can anyone know how to do this I hope it helps!

Thanks, Vinutha! I have already been through the above link. I’m able to extract the body of the mail along with other details from the solution provided there. https://forum.uipath.com/t/how-to-write-email-body-table-to-excel-file/2141/15?u=rishivc1 The above technique gives sender’s name, subjec…

Hey, thanks :slight_smile: I will update as soon as I will implement it.Trying :slight_smile:

[image] Vinutha: Open the saved .eml file using start process activity.(it will open in Outlook). Hello Vinutha, I’m stuck here. Every time when I run my Bot, I end up getting this error: [image] This is how my Start Process property window looks: [image] Any Suggestion? Thank you.

@RishiVC1 Reply to your message: Start process activity with path of .eml file. Also set outlook as default application to open eml file. Use build data table to create an empty table with headers. Use write range without excel application scope and write the table in .xslx excel file. Now use …

Could you please tell me by looking at the screenshot attached, where I’m going wrong ? FolderLocation is the variable that contains the location of directory where .eml file is stored .

Just give the eml file path in start process activity instead of outlook path… No need to give argument and outlook path

Hi. I’d tried this approach. My Outlook 2016 launched but it didnt open the .EML file and there is no error message also. [Image 14]

I tried this method also but challenge is defining the Selector. I use the Selector to be the file explorer window. But when i run the workflow i got the following error. [trying to launch eml file directly]

Set the default application for opening eml as Microsoft Outlook in its properties. Open it using start process activity in UiPath. Input is the path of eml file. Avoid using idx in the parent selector.

Extract Table from Outlook

Help

Vinutha May 23, 2017, 12:22pm 2

Hi,

Check the below link.

I hope it helps!

2 Likes

Mail reading

Topic		Replies	Views
Outlook Mail Activity Help activities	6	2275	May 30, 2019
Extract table from Outlook Mail body Help	6	6478	December 30, 2019
Only Table extraction from Outlook Help datatable , excel , activities	4	2681	March 5, 2019
Table in email body Help	3	1160	October 31, 2019
Extracting Table from Outlook Email Body Activities excel , extract	3	1540	February 25, 2023

Extract Table from Outlook

Related topics