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

Help
,
1

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

2

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

3

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

Regards,
Praveen

4

So simply you can use Write Cell.

5

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

6

Iam getting those data’s into add data row,

image
image1366×768 68.4 KB

*match_split is “match regex”

Any suggessions please.

Regards,
Praveen

7

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

8

Thanks a lot @Karthick_Settu

Regards,
Praveen

1 Like
9

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