Embedded Files
Creating Student Email Lists in PowerSchool
Creating Student Email Lists in PowerSchool
Within your PS attendance page, you have the option to create an email list of the students and/or guardians for each of your classes for the current term.
Select the Email List icon.
2. Select which student email addresses and guardian email addresses you would like to include in your list.
3. Copy and paste the list of emails.
If you are making a CSV of your student emails, you may need to separate the email addresses from one cell into separate cells using the "Split text to columns" tool and then transpose the data.
Click the cell (A1) that contains the list of email addresses.
Go to the Data tab in the menu.
Select Split text to columns. A small pop-up will appear with a dropdown menu.
In t
Select Split text to columns. A small pop-up will appear with a dropdown menu.
In the dropdown menu, choose Comma as the separator. This will split the email addresses into separate columns.
Now that the email addresses are in different columns (A1, B1, C1, etc.), select all of them by clicking and dragging across the row.
Cut the selected cells by pressing Ctrl + X (or Cmd + X on Mac).
Click on the first empty cell where you want the list to start, for example, cell A2.
Right-click the cell and select Paste special, then choose Transposed. This will paste the data from the columns into rows, placing each email address in its own cell in column A.
Page updated
Report abuse