I have the excel data which includes Outlook email IDs. I wanted to retrieve details from outlook like Designation, Office Location and Office phone number into excel. Excel data: Email IDs Office Location Designation Office Phone Number xyz@xy.com xyl@xy.com I found one link whose coding I tried but it's not working for me. I have learned VBA but I on beginner level. https://stackoverflow.com/questions/30159320/retrieve-outlook-details-based-on-alias-name-excel-vba Can someone help me in building the same. Thank in advance.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Retrieve Employee details from Outlook

Thread starter meetz
Start date Dec 22, 2017
Tags

designation excel office outlook phone

meetz

New Member

Dec 22, 2017

I have the excel data which includes Outlook email IDs. I wanted to retrieve details from outlook like Designation, Office Location and Office phone number into excel.

Excel data:
[TABLE="width: 600"]
<tbody>[TR]
[TD]Email IDs
[/TD]
[TD]Office Location
[/TD]
[TD]Designation
[/TD]
[TD]Office Phone Number
[/TD]
[/TR]
[TR]
[TD]xyz@xy.com
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]xyl@xy.com
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I found one link whose coding I tried but it's not working for me. I have learned VBA but I on beginner level.

https://stackoverflow.com/questions/30159320/retrieve-outlook-details-based-on-alias-name-excel-vba

Can someone help me in building the same.

Thank in advance.