REG:Outlook employee information

Hi All,

How to get the outlook contacts for the organization using excel macro vba.

Thanks,
Lakshmanan

Hi Adyteo,

Thanks for the response...I have seen the post which one you posted.But that is related to send mail to manager.But here my need is I want to get the details of a employee when click the employee ID.The macro which should retrieve all the details which are present in the outlook properties window..

Requirement:

1.General tab information
2.Organization information
Phone/Seat information


The macro should fetch and display all the outlook property details present in the Outlook properties window.


Thanks in advance.
Lakshmanan

Hi Adyteo,

Thanks for the reply.The details should be displayed in the macro embeded work sheet itself.

The details requirement:
The option should be present in the macro where i need to enter the employee id ad hit run to retrieve the result.

The macro should call the oulook properties window and should retrive all the details present in the emloyee outlook properties window.If i fill 10,20..N...number of employee id and hit run means it should display all the employee's outlook properties details should display.This is the challange here.

Thanks in advacne.
Lakshmanan

Hi Adyteo,

Thanks for the code.When am trying to implement ..its throughing error..like "Comile error-User defeined type is not defined"

Can you please share me the excel which code implemented..

Thanks,
Lakshmanan

Hi Adyteo,

Thanks much.It is running with out any error..After run it is displaying only the Below item in the respective cells.even after entering the employee id of our employees it is not showing the result and detils of the oultook properties window.And am using Ms office 2010..

email or Name Name email address Department Job Title Office Location Company Telephone Manager


The above thing is only displaying..Can you please look into that issue and help me on the same..

Thanks,
Lakshmanan

Hi Adyteo,

Thanks for the advice..

Its running perfectly...But it is not retriving the "Seat NUmber" for the employee..present in the Phone/Seat tab of the outlook properties window..If i want all the information present in the out properties what i can include in the code.

Thanks,
LAkshmanan

Hi Adyteo,

Here Particularily i wan to display the "Seat Number" present in the outlook properties window.Can any one take a look and help me on the same.

Thanks,
Lakshmanan

OK adyteo..Thanks for the info.Is there any website to serach that item ..pls share here..Else what i can do if i know the filed name.

Thanks

Sure..BTW that anyone in this forum find that Seat number query means .please post.

Thanks.
Lakshmanan