Read the table from email and store data in excel sheet in different columns

[niharika2412 (Niharika)]

I want to extract the data from email… which is in tabular format… and put it in excel sheet in different columns… Kindly help

[sarathi125 (Parthasarathi)]

Hi,

Give some sample format of your mail and excel sheet.

[pavanh003 (Pavan Harisha)]

Hi,

Please follow the below chain, this will solve your issue.

How to write email body table to excel file

You can try this: Get the mail message using ‘Get Outlook Mail Message’. Save the email(mail message) as .eml using ‘Save Mail Message Activity’. Open the saved .eml file using start process activity.(it will open in outlook). Ctrl + A and Ctrl +C (Copy) on the email page and Paste the text into excel file. Save the excel and get the content into Datatable using Read Range Activity.

Regards,
Pavan H

[rkiran0307 (Ravikiran Radhakrishnan)]

@pavanh003
I have extracted and saved the data as .eml file. Please advise how to do copy and paste operation. .xaml file can be helpful.
Thank you

[wasea (Vasile)]

Hello @rkiran0307 ,

What you want to copy from your emails and where to copy?

Nobody will provide a xaml file, because your request is too vague. Please provide some more details, some examples if possible and we can provide better answers.

Also, there are some posts related to this, did you run a search on the forum?

Vasile.