N/APosted on - 07/01/2014
I have a very long list of names, first names, last names and middle names in Excel, but I only care about those that have email accounts. If I could loop through the excel sheet and get the email and OU then export it to the excel sheet, that would really be great. Can I do this in Powershell? How do I actually go about doing it? Thanks!
How to export email addresses from Excel using Powershell
Powershell is not necessarily the best tool for this task. It is not designed with this use in mind, or frankly any practical use. I suggest scripting in Python. There are fully developed python libs and other tools specifically for this purpose. You can quickly create what you need. There is a wealth of information online including documentation, sample code, and assorted guides for various tasks. Utilizing a search engine should yield all the information very quickly.