Get "On befal of" Email Address

[jan.exner]

Hello All,

please how to get “EMAIL 2” into a variable? When I give “Email.From” I get “EMAIL 1”.

I’m using the GetOutlookEmailMessage activity

Thanks a lot,
John

[praseedplk (Praseed)]

@jan.exner

MAIL

1.Take the Subject into a string variable.
2.Split the subject with “on behalf of”, Take the split value in a string array variable(Split).
3.Split(1).Tostring.Trim will give Email2.
4. Split(0).Tostring.Trim will give Email1.

Try this and let me know.

[jan.exner]

Hi @praseedplk,

Unfortunately, this is not a “Subject” field, but a “From” field (email sender).

[praseedplk (Praseed)]

Try item.From.ToString instead of item.Subject.ToString → Take into string variable and continue as above.

[jan.exner]

It has already been tried and “EMAIL 1” will pull me out.

[Pratik_Wavhal]

Hi @jan.exner

So on From Field why dont you use the Regex to Extract Both the Email ID’s

As @praseedplk said item.From.ToString you might get the whole line as a string Right ??

Then As per the Google below is the Regex for the same :-

([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+).([a-zA-Z]{2,5})

The Above Regex will give you the Email Id’s from the From Field

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[jan.exner]

@Pratik_Wavhal

So on From Field why dont you use the Regex to Extract Both the Email ID’s

As per the Google below is the Regex for the same :-

([a-zA-Z0-9_\-\.]+)@([a-zA-Z0-9_\-\.]+).([a-zA-Z]{2,5})

The Above Regex will give you the Email Id’s from the From Field

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

If I use Mail.From I always get only “EMAIL 1”, so I can’t use this

[jan.exner]

Please, help me !