Banner is a great resource for storing student information. However, extracting the information from a screen by scrapping (i.e. copy and paste) requires a few extra steps for the email addresses.

Email addresses are dumped to a new Outlook email form in the Bcc section. Converting this blob of email addresses into an Excel list takes a couple of steps.

  1. Copy the list from the Outlook email form
  2. Paste into NotePad++
  3. Search and replace the "; " (that is semi-colon and a space), with a "\r\n". In the Search Mode box, check the button for "Extended" mode. (NOTE: \r\n = Windows newline )
  4. Copy and paste the lines of the list from NotePad++ into Excel.
  • Of course capturing the list of students from Banner and pasting into Excel is a bit more direct by:
    1. highlighting the columns and rows on the screen and Copy
    2. Paste into Excel as Text

Total Count: 561511 | Page Views: 508

For a long time it had seemed to me that life was about to begin - real life. But there was always some obstacle in the way. Something to be got through first, some unfinished business, time still to be served, a debt to be paid. Then life would begin. At last it dawned on me that these obstacles were my life.

Fr. Alfred D'Souza

What is Banner?

Banner is an enterprise system for higher education. It is a student information system. More details at


We overestimate what we can accomplish in a day, but underestimate what we can accomplish in a year.

Chris Guilleabeau

Page Views: 508 | << | Trail Index | >> | HomeLinks