- Reports
- Custom Reports
Click the fields needed via Student, Parent, and Status (e.g., parent address information, program status, etc.). Then, click View.
Once the information loads, click the Excel icon in the top corner of the report cue.
Windows will display a message prior to opening. This message informs the user that windows will try to save this file with a different file extension. *See instructions below for saving this file.
When Excel opens, choose Yes and click Enable Editing, if prompted.
Click inside the first blank column and the first blank row (Cell I1 in this example), and type "To the Parents of:" in the cell.
Copy this cell by right clicking and selecting copy or by clicking Ctrl + C (for Windows) or Cmd + C (for Mac).
To paste the information into the other column cells, click and drag the "+" symbol in the right corner of the cell and drag it all the way down to highlight all the column cells and release to paste "To the Parents of:" in bulk into all the cells in this column. You can alternately click Ctrl + V (for Windows) or Cmd + V (for Mac) on the keyboard to individually paste the cells.
Click inside the next blank column and row and type the formula "=concatenate("
From here, you will enter the numbered cells so that the field populates with the "to the parents of" field, followed by the students first name, last name, mailing address, city, state, and zip. In this example, the final field would display as "(=CONCATENATE(G2,B2,A2,C2,D2,E2,F2)" Once entered, hit Enter (for Windows) or Return (for Mac) on the keyboard.
Copy cell H2 and paste to the other cells by right clicking and selecting Copy or by clicking Ctrl + C (for Windows) or Cmd + C (for Mac) on the keyboard. To paste the information into the other cells, click and drag all the way down to highlight those cells and paste by right clicking and selecting Paste or by clicking Ctrl + V (for Windows) or Cmd + V (for Mac) on the keyboard. You can also click and drag the far right edge of the cell (where a "+" sign appears).
Click to highlight column I, right click, and choose Paste Special.
In the Paste Special toolbox, click Values. Then, click Ok.
Now that all the information is displaying in the new column, you’re ready to open a Word document and copy/paste the information into a page of labels.