Only Table extraction from Outlook

[haria05a7 (Hariprasad)]

Hi ,

I want table from the email body into excel

Can anyone do needful thing

[PrankurJoshi]

HI @haria05a7

See this

Extract Table from Outlook

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 file. Any suggestions or right approach on how I can extract the tables/individual column values from the body? Solution with examples will be much appreciated? Thank you.

Thanks,
Prankur

[haria05a7 (Hariprasad)]

Can u send sample Xaml ,

[haria05a7 (Hariprasad)]

@PrankurJoshi

i want only the table not the text present in the body of the mail

[sanjay21051990 (sanjay shankhla)]

HI @haria05a7,

Here you go
You can achieve using the following Property

GetInspector.WordEditor
This property is useful for returning an Inspector object in which to display the item, as opposed to using the Application.ActiveInspector method and setting the Inspector.CurrentItem property. If an Inspector object already exists for the item, the GetInspector property will return that Inspector object instead of creating a new one.

and typecast the object to word document

 xDoc=CType(MailItem.GetInspector.WordEditor,Microsoft.Office.Interop.Word.Document)

and get the list of table using the the object xDoc
xDoc.Tables.Count

Check the sample below
OutlookInvoke (1) (1).xaml (8.7 KB)

Regards
Sanjay Shankhla