Hi everyone,
I need advice on the best way to conquer my latest problem, I'm thinking maybe using a web query. Anyway, I have a worksheet where Column K, contains our users names (lastname, first). I am trying to populate another column with the appropriate email for each person. The only way I can think of getting that data is by doing a query using the web interface of our LDAP.
So I would like to take the value from column K and stick it in here:
http://ldap.directory.myCompany.com/cgi-bin/DS/search.cgi?search_type=CommonName&search_string=[ValueFromColumnK]&listing=short
then hopefully, create a loop that will populate each cell with the appropriate email to look like this:
Column K Email Column
Doe, John johnd@co.com
Doe, Jane janed@co.com
I need advice on the best way to conquer my latest problem, I'm thinking maybe using a web query. Anyway, I have a worksheet where Column K, contains our users names (lastname, first). I am trying to populate another column with the appropriate email for each person. The only way I can think of getting that data is by doing a query using the web interface of our LDAP.
So I would like to take the value from column K and stick it in here:
http://ldap.directory.myCompany.com/cgi-bin/DS/search.cgi?search_type=CommonName&search_string=[ValueFromColumnK]&listing=short
then hopefully, create a loop that will populate each cell with the appropriate email to look like this:
Column K Email Column
Doe, John johnd@co.com
Doe, Jane janed@co.com