How to get webpage Url's from email body and save them into excel

Hello Team,
–Iam getting mails through outlook,those mails consists of lot of webpage url’s .
*I did regex to get those url’s from mail,but i cant able to add every urls into excel…
*please give me some ideas with that.!
*note -mails have more than 10 url’s

Regards,
Praveen

Hi @praveen23395
Suppose you got the Urls in Arrayof string. After that Iterate that array using Loop and use the Activity “Write Cell” To add one Url in Excel Sheet. use the counter while giving the range to write cell. and after that increase the counter by one in this way you can put all Urls in One column which you want.
Thanks & Regards

hello @jitendra_123
but i want those url’s into single cell

Regards,
Praveen

So simply you can use Write Cell.

Try to Append each URL with Environment.NewLine to a string and then copy it to the excel cell.

Iam getting those data’s into add data row,

*match_split is “match regex”

Any suggessions please.

Regards,
Praveen

Hello team,
Refer my workflow @Karthick_Settu @jitendra_123
Please look into Filter webpage sequence ,and give some ideas with that.

Main.xaml (34.4 KB)

Regards,
Praveen

Thanks a lot @Karthick_Settu

Regards,
Praveen

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.