Does The Employee Exist

[scm160]

I'm creating a macro that automates the creation of Org Charts on Visio....

When the macro loops through specific names in a list I want to check to see if the employee exists within our company.

Potential Solution (untested):

Go to I.E. to employee directory website. Search the person's name - if the person's name appears then we have a match!


Is there any better way of doing this? I also have the user's email if I have their correct first and last name because the nomenclature is the same when employees are given email addresses.

firstname.lastname@xyz.com

Sortof like CheckName in Outlook

 

[wideboydixon]

Take a look here for resolving e-mail address / names in Excel:

vba - Creating a "Check Names" button in Excel - Stack Overflow

WBD

 

[scm160]

Take a look here for resolving e-mail address / names in Excel:

vba - Creating a "Check Names" button in Excel - Stack Overflow

WBD

Hey wideboydixon - following up. Thanks for directing me to that site. The macro works like charm. Also noticed 500+ posts in 1 month on the forums. real impressive

 

[wideboydixon]

No problem. Here's why I have 500+ posts:

WBD