InfoPath Dev

I currently have an Excel Spreadsheet that allows the users to copy and paste information into it. When pasted, the fields will change colors based on the information in specific columns through conditional formatting. Also, I wrote a Macro that would take whatever is selected and separate that into another spreadsheet, attach that to an E-Mail, and send the E-Mail to the addresses I have specified. I would like to have a form that uses InfoPath and will allow the users to copy and paste 8 Columns worth of information and a changing number of rows into the form. I would also like this form to be able to detect a name in the column and send all of the columns with that name in an E-Mail to the person in the column. I have a database of information that I can verify the names pasted with a sheet of info and output the E-Mail address associated with it. Any suggestions on how to accomplish this?

InfoPath doesn't directly connect to Excel very well.  Perhaps you can use the Excel sheet to create a list in SharePoint and then connect to that list using InfoPath.  Copying and pasting somewhat works from Excel to a repeating table in InfoPath, but I've seen many bugs using that capability.