How to get Outlook User Mail ID Properties to Excel

Madhusudhanan S

New Member
Joined
Feb 2, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi Team,

I would want to extract outlook mail id properties to excel. I have the email IDs of the user in one column and i would like to extract the country/region from outlook of the corresponding . I do not know whether we have direct excel formula to extract it or would have to write VBA code for the same. I am using office 365 excel.

I have seen similar thread here : How to get Outlook Mail ID Properties to Excel - Challenging Problem

The thread was pretty useful. My requirement is, the code have to read the email ids from the excel sheet and have to add the outlook properties of the user to next column.
Could some one please help here

sample.JPG
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,214,919
Messages
6,122,259
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top