Use OLE automation from your application to create an EXCEL object. Once you have a code reference to the object you can manipulate it through code (Add workbooks, worksheets, save the file, etc..). Depending on your Email system (Outlook, Groupwise, Lotus Notes) you can write code to attached the file and send it much the same way you created the Excel file. The code is not extremly difficult but depending on your exact needs it may be lengthy. Check out Microsoft.com for examples of OLE automation.
Good Luck
Neal Martinelli