https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/83006.aspxTue, 25 Sep 2012 16:55:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:83006Anson Hidajat0https://www.infopathdev.com:443/forums/thread/83006.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=83006InfoPath 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.https://www.infopathdev.com:443/forums/thread/82800.aspxTue, 18 Sep 2012 18:11:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:82800zero69721020https://www.infopathdev.com:443/forums/thread/82800.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=82800I 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?