vedictuning
New Member
Hi,
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
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