Vba check names

[mohamed ali abdelgawad]

Hi all
I on aompany that have exchange mail
When I type User10 in outlook and click check names I fount that this name converted to be employee mail like Mohamed.ali@dmain.com
I want to do this in excel
But after searching a lot I find 2 macros
First one return if mail exist or not and give me true or false
Second one give me user1@domain.com but don’t give me full name like outlook

So I want macro to return full mail like check name do in outlook

Thanks

 

[mohamed ali abdelgawad]

any reply please