The steps below will explain how to run a custom report with parent address information and how to create labels using Office 2010.
- Reports
- Custom Reports
When the Custom Report cue opens, click the checkbox beside Last Name, First Name, Mailing Address, City, State, and Zip from the "Parent" column.
With these options selected, 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.
Highlight the Student ID, Student Last Name, and Student First Name columns and click Delete.
Column A shows as Parent Last Name, Column B shows as Parent First Name, and Column C shows as Mailing Address. Change Column A to Last Name, change Column B to First Name, and change Column C to Address.
Once the template is ready, click File > Save As and choose the location to save the report (i.e., Desktop, Documents,). As you do this, enter in a title for the report in the File name field; then, click the dropdown and change the Save as type to Excel Workbook or Excel 97-2004 Workbook.
Once you are finished, click Save and close the spreadsheet.
The spreadsheet will now be ready for you to proceed with setting up the mail merge.