I apologize if this is the incorrect forum to post this question..but here goes.
I have an Excel spreadsheet with user information..ex first name,last name, phone number, alias, location. What i need to do is take the information from the global address list in Outlook using Exchange Administration (which i have done already and created a .csv file) take the info from the file and export it to the Excel spreadsheet and have it basically fill in the blanks. But i only want it to take the info csv..match the names in the Excel sheet and fill in the blanks of what it needs. Ex. the csv searches Excel and finds John Smith..sees that John Smith still needs his phone number updated and his alias..so it auto fills in that information in the appropriate column and looks for another name match.
Ive tried a few add-ins and the ones i have tried arent working they way i need them too. So at this point im thinking i need to write my own..unless somone has a quicker way to do this. I was going to use Conditional Formatting but i dont think that would work also.
I have an Excel spreadsheet with user information..ex first name,last name, phone number, alias, location. What i need to do is take the information from the global address list in Outlook using Exchange Administration (which i have done already and created a .csv file) take the info from the file and export it to the Excel spreadsheet and have it basically fill in the blanks. But i only want it to take the info csv..match the names in the Excel sheet and fill in the blanks of what it needs. Ex. the csv searches Excel and finds John Smith..sees that John Smith still needs his phone number updated and his alias..so it auto fills in that information in the appropriate column and looks for another name match.
Ive tried a few add-ins and the ones i have tried arent working they way i need them too. So at this point im thinking i need to write my own..unless somone has a quicker way to do this. I was going to use Conditional Formatting but i dont think that would work also.
