How to export specific text from the body of outlook email to a excel?

[Arjun_Prasad]

The body of the email contains following details:

Website URL: https://visalienminh.vn/visa-dinh-cu/bao-lanh-hon-phu-hon-dinh-cu-uc-visa-300.html
Name: nttravn
Email: nxxx83@gmail.com
Phone: 0908923567

how to export each of these values of website, name, email, phone to a excel?

[minhduc]

Hello @Arjun_Prasad
I did try one process same you say?i don’t know it same think about it

[Arjun_Prasad]

Thank you.

Tried to extract the sting using regex match activity.

I have encountered another issue with this. I am trying to read body of the emails from outlook which has following details and get The value of website URL, Name, Phone, Email etc… using regex match and testing it a write line activity.Website URL: http://www.somthing.com
Name: Something
Email: Something@Something.com
Phone: 12345
Referal URL: https://www.Something.com/search?q=Something&src=IE-TopResult
Referal Landing URL: Something.com/
IP address: 255.255.255.205
Affiliate Id: 1234

In few email body some of these details are missing. e.g, Referal URL will not be present. In such cases I get ‘Object reference not sent to an instance of an Object Write line error’. How to assign the value of those missing strings as ‘N/A’?

[minhduc]

Hello @Arjun_Prasad

Can you provide your .xaml file.
I did not get the error you described

[aanandsanraj (Anandraj Rajendran)]

hi @Arjun_Prasad,

Can you provide the full body of mail?

[Arjun_Prasad]

Thank you all. I solved the issue with the help of this solution in this post Object reference not sent to an instance of an Object - #8 by Arjun_Prasad