• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Connecting excel with open outlook properties need help


New Member

I have a file with email addresses . I have to open a new mail in outlook. Then copy each email address. Right click and open outlook properties. From outlook properties I need to extract the datas first name, last name, alias, title , company, department, country, address, phone number. Then I need to go to the organization tab and find the manager of the individual. Then I need to move to the phone/notes tab and take fax number, business phone number and mobile number. I need to fill the excel sheet with respective details.
I also want to mention that the address part in "open outlook properties has multiple lines.
For eg: XYZ company
1st cross
New zealand
So these lines are pasted in consecutive cells when they need to be in one cell.
Attached is the file for reference