Asked By
ayannahana
10 points
N/A
Posted 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
Hello,
Â
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.
