Read table from outlook mail body

Help Studio
1

Hi,

There is html table in mail body. We have read html table and paste it in excel file. How we can acheive that ?

2

@Shirish Have you tried this Activity :

3

Could u please help - How to use it. I have downloaded it.

4

@Shirish How many Tables will be present in the email? Will it be always 1 or more than 1 ?

5

only one table

6

@Shirish Go to Manage Packages in Studio , And Install the Activity Shown in the Image below :

ExtractTables
ExtractTables1036×643 55.6 KB

7

cant find it…

8

@Shirish Go to Settings in Manage Packages and make sure you have selected all the Package Sources and try finding the Activity again.

9

Got it. When I am using it, it is throwing error.

Error is - System.NullReferenceException: Object reference not set to an instance of an object… Can u please check…
at Get_DataSet_from_MailMessage.ExtractTablesFromEmail.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

image

10

@Shirish Apologies for not informing earlier, In the HTMLText Property of ExtractTable Activity use item.Headers(“HTMLBody”).ToString, Considering that you have changed the Type Argument in For Each to System.Net.MailMessage

11

ok…how to add dataset to excel ??

12

@Shirish So were you able to extract the Data ? Also how do you want the Data in the Excel ? One Sheet Should Contain All the table data or Should it be in different Sheets?

13

there is no such property is available…

image
image353×683 8.95 KB

14

@Shirish Ohh The I guess you’re using a different version or a Different Activity, It’s ok, You can use the same Activity. Can you tell me what is the mail variable in the Mail Message Property?

Also Can you Provide the Workflow , I can update and send you back.

15

ExtractDataFromEmail.zip (14.4 KB)

Also tell how to write data to Excel from dataset

16

@Shirish How do you want the tables in Excel ? All the Tables from Different Email Mesages to be combined or should it be in different Sheets ?

17

in different sheet

18

@Shirish Check if this Works :
ExtractDataFromEmail.zip (16.7 KB)

19

This code is not extracting table from email body

20

@Shirish Does it give errors ?