The Banner report SWRCLEM generates a list of student emails based on a given subject code (for example, MTH for Math students, WR for Writing students). The report can be further narrowed down by campus. SWRCLEM can be downloaded into Excel and, if desired, used to create a mass email.
Two versions of the report are generated in Banner Report Viewer, one ending in .lis and the other ending in .txt. The .lis version lists only the number of students who were selected. The .txt version shows all MyPCC email addresses; it is also the download-friendly version.
- From the Banner Main Menu page, type SWRCLEM, then press Enter.
- Click the Go button and then the Next Section
3. On the right side of the Parameter Values section (see picture above), type in the Term Code.
4. Press the Down Arrow on your keyboard (or click with your mouse) to navigate to the second line, the Subject Code line.
5. Type in the Subject Code (for example, WR for Writing) for the academic subject you want.
The report will show the MyPCC email addresses of all students enrolled in classes associated with the Subject Code you specify here.
6. Type in the Campus Code if you wish to narrow your data down further by Campus. OR, leave this field blank if you don't want to narrow it down by campus.
- 1 = Sylvania
- 2 = Cascade
- 3 = Rock Creek
- 4 = SE Campus and other ELC locations
- blank = all campuses
To specify more than one subject,
7. Click the Next Sectionicon.
8. Click the Save icon.
(For more information about running reports, including how to save your parameters for next time, see the Banner Report Help page.)
9. Open Report Viewer and view your report.
Two files are created for this report. The file name that ends with .txt is the report you will need for downloading. (The report with ".lis" at the end of the file name will only show the parameter values you have entered and the number of students.)
To download the .txt version of the report, go through the Downloading Process to save and convert your report into Excel format. (Note: When you open the file in Excel, choose "delimited" and indicate "tab" as the delimiting character.)