advice on maybe using web query

dhx10000

Board Regular
Joined
Jul 11, 2005
Messages
144
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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
in the absece of data this can only be a vaue suggstions

download the email data from your company webpae on sheet 1

on sheet2 in column A you can enter the names you are interested in and in column B use vlookup function. this will pick up the appropriate email address pertaining to the name in coumn A from sheet 1. if necessary see help under <vlookup>
 

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,509
Members
412,599
Latest member
Schu94
Top