Extract text from email body to variables- office360

[Vishal_Verma1 (Vishal Verma)]

Hi All,

I have to read outlook email body and extract the below column and save into data table.

[rlgandu (Rajyalakshmi Gandu)]

@Vishal_Verma1

Extract text from email body to variables?

Hi @salmantahir31 Welcome to Community!! [image]

Check this thread also this also helps for you

Extract text from email body to variables?

@salmantahir31 Welcome to the community Please try this in assign Arrayvalues = Str.Split({","},Stringsplitoptions.None) Let us say body is stored in str and assumption is only the value you required are present…if not please let us know we can change the expression Arrayvalues is an array of strings which will contain each string as seprate value To get each use the index arrayvalues(0) will give the first value similarly for all values If you need each value in loop then pass arrayvalue…

[ashokkarale]

@Vishal_Verma1,

Get your email body as html string. From this string you can use Regex to extract it easily.

Thanks,
Ashok

[Parvathy (PS Parvathy)]

Hi @Vishal_Verma1

I have replicated and extracted the required data to excel. Here is the zip file. Let me know if it works.

ExtractTextfromEmailBodyusingOffice365.zip (153.5 KB)

Output:

Hope it helps!!

[Vishal_Verma1 (Vishal Verma)]

Thanks @Parvathy for helping, please what package i need to install as i see error of missing activity.

[Parvathy (PS Parvathy)]

Hi @Vishal_Verma1

Please download UiPath.MicrosoftOffice365.Activities

Go to Manage Packages → All Packages → Type UiPath.MicrosoftOffice365.Activities → Click Install → Click Save.

Please change the Additional Filter options according to yours.

Regards

[Vishal_Verma1 (Vishal Verma)]

Hi @Parvathy, thanks for the help, i need lil more help in this case. I have to read different format too, can you help me to make it dynamic. From the table i have to read ‘Tenant Code’ and ‘Tenant Name’ from other emails table.