How to get mail.To email address only and not the display name

[darshini]

Hi, I am trying to use mail.To to get the email address of the email recipient. However, I get it in a format which has the display name as well. How can I format it to only give me the email address?

[kalyanDev]

use properties like yourtemailvarible.to it will give you to address.

[harshit_singh]

Hi @darshini
You can use yourMailMessageVariable.Sender.Address to get email address only.

Cheers!

[darshini]

I used mail.To but the value comes as ‘Displayname’ username@xxxxxx.com in excel rather than just username@xxxxxx.com

mail.Sender.Address won’t work as it will give me the sender address but i need the recipients address

[harshit_singh]

@darshini
In that case, you have to use regular expression or string manipulation.
If you use regex then follow below steps:-

1. Use Assign activity - MailAddress = System.Text.RegularExpressions.Regex.Match(ToMailVariable,“([\w.-]+)@([\w-]+)((.(\w){2,3})+)”)
2. Now print MailAddress it will give you only mail address without Display Name.

I hope it’ll help you.

[alexologica (Alexander)]

Mail.To is collection of emails

You can use:
Mail.To(0).Address for getting first recipient email,
Mail.To(1).Address for getting second recipient email, and so on.

The easiest way, just use for each to iterate each mail address in Mail.To

[darshini]

Hi I tried the above and it works Thanks a lot!!