Mental Health in Schools Act of 2007

Mental Health in Schools Act of 2007 - Amends the Public Health Service Act to make changes to the program to apply a public health approach to mental health services, including by revising eligibility requirements for a grant, contract, or cooperative agreement. Makes only a consortium that includes at least one educational agency eligible for such funding. Allows such a consortium to: (1) include a community program, an agency that is involved in mental health, or a school; and (2) consist of a consortium in which the members select an agent (such as a local educational agency or community health care entity) to act on the consortium's behalf.

Sets forth assurances required for eligibility, including assurances that: (1) the local education agency will enter into a memorandum of understanding with relevant community-based entities that clearly states the responsibilities of each consortium member; (2) the program will include comprehensive staff development for school and community service personnel working in the school and training for children with mental health disorders, for family members of such children, and for concerned members of the community; and (3) the program will demonstrate the measures to be taken to sustain the program after funding terminates.

Requires the Administrator of the Substance Abuse and Mental Health Services Administration to develop a process for evaluating grant program activities, including: (1) the development of guidelines for the submission of program data by recipients; and (2) the development of measures of outcomes to be applied by recipients in evaluating programs, to include student and family measures and local educational measures.