Hi all,
So I'm trying to import a CSV containing some email address and for each, I would like to list all the smtp addresses in a well readable format.
Is this achievable with any script?
Ive tried to import CSV and pipe it to use the get-recipient command like this..
Get-Content "C:\Users\name\Downloads\strange.csv" | foreach { get-recipient | select displayname,primarysmtpaddress,emailaddresses } | Export-Csv C:\Users\name\Downloads\strangers.csv
but sadly, it runs the command for the whole domain instead of just the selected contacts in the csv and it prints the emailaddresses in a horrible format that so long to review that it becomes work itself.
what am i doing worng?
is this the right command for my goal?
is there a good script to help me achieve my pursuit?
any help will really be appriciated.
Basically, what I want to do is convert this:
https://preview.redd.it/i915h9i14q341.png?width=655&format=png&auto=webp&s=9b7cd9a49c87506d8813fbfedfd3711bd461493d
Into this:
https://preview.redd.it/gp3rbw0c4q341.png?width=483&format=png&auto=webp&s=3f2607cdbea0f8d85609a9380930275b3c1c788d
There really should be an easy/fast way to do this. Something like: selecting files in explorer, right click, export to Excel. Buuut there isn't. Also, the whole "Copy as Path" is useless for what I want. My files names are an absolute mess but the data collected in the other columns is pretty fine. I want to be able to add any columns I want and copy that data to excel, be it for music playlist, images, etc. I just want my detailed explorer list to show in Excel. How can I do this?
