SQL Server 2005 Split email text field to a view table

Having read through multiple, very good, high powered options for splitting delimited text columns I have come to the conclusion that I need assistance dumbing it down for a relative newbie to SQL Server.

Explanation of the issue: I am at the mercy of the previous programmer. Sigh. We have an (1) email column entry for shipments in our existing unmodifiable system. When we have more than one receiver we place multiple emails in the column delimited by commas (BAD design !!!).

A shipper has edited their program to accept multiple key columns and manually split the email column into separate email columns. Other shipper's programs can't be changed. I am using MY view table for concatenated key columns to feed the data to the secondary programs - which works for all instances except when the email column contains more than one email address.

Explanation of (a) Resolution:

I need the original email column intact in the view table and (5) more columns added to my view table with a possible email address parsed from the original column. This needs to work for the existing rows and any future rows. I assume that one AlterTable or AlterView statement will do the trick.

TIA++