You can use Control Panel’s Administrator Tool called Active Directory Users and Computers to export your users with their email address information. To export the list, you must highlight the Users container in the right pane, and right-mouse click to select Export List… as shown below. (Note the changed column headings that are displayed matches the above table.)
You will then be prompted to specify the location, filename and file type for this exported list. It is recommended that you save directly to the PLGV folder under C:\Program Files\CMS Praetor G2. Be sure to choose to save the file in the comma delimited CSV format as shown.
The exported CSV will include many entries that are not relevant to PLGV and only those entries with valid email addresses are significant. For example, you will likely find entries with a Type value of “Security Group – Global” or “Security Group – Domain Local”, but there are also “User” entries that are not relevant that have no email address such as those for built-in accounts for various processes or applications.
All the entries without any email address need to be deleted and the “Description” field needs to be replaced with a temporary password. If you want to make the temporary password different for each user, then you can manually do this by importing the CSV file into Microsoft Excel.
Give dumpsec a try. It is a very useful tool for these purposes.
Another great powerful FREE tool for managing/reporting AD is PowerGui. It will do much more than Active Directory too.