Here's what you do:

1. convert the document to plain text
2. import into excel; semicolon delimited
3. copy the row of data, click a new cell, transpose to get the data in one column 4)in cell B1, paste this: =IF(ISNUMBER(FIND(",", MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1))), MID(A1, FIND(",", A1)+2, FIND("""", A1, FIND(",", A1))-FIND(",", A1)-2), IF(ISNUMBER(FIND(" ", MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1))), LEFT(MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1), FIND(" ", MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1))-1), MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1) ) )

That will grab the name whether it's formatted "first, last" or "first last" and if neither, just paste the value inside the "" 5) in cell C1 paste this: =IF(ISNUMBER(FIND(",", MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1))), LEFT(MID(A1, FIND("""", A1)+1, FIND(",", A1)-FIND("""", A1)-1), FIND(",", A1)-FIND("""", A1)-1), IF(ISNUMBER(FIND(" ", MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1))), MID(A1, FIND(" ", A1)+1, FIND("""", A1, FIND(" ", A1))-FIND(" ", A1)-1), MID(A1, FIND("""", A1)+1, FIND("""", A1, FIND("""", A1)+1)-FIND("""", A1)-1) ) )

will do the same for last name 6) Paste this in C1: =MID(A1, FIND("<", A1)+1, FIND(">", A1) - FIND("<", A1) - 1)

-- Pulls the email address out

Done!