title: Get-AdUser where mail is not null
body: <p>I am trying to get a list of all users in AD that have an email (mail attribute). I have this command </p>
  
  <pre><code>Get-AdUser -filter * -Properties mail | Select SAMAccountName, mail | Export-CSV -Path $userPath -NoTypeInformation
  </code></pre>
  
  <p>The problem is that I do not know how to limit or filter out users where the email is null/blank. I do not care how complex the script is as it will be part of a much larger powershell script. If the solution is to loop through the CSV that is an option but would prefer something quicker. Does anyone know how to do this?</p>