Have a look at this - it should get you moving in the right direction:

http://www.freevbcode.com/ShowCode.Asp?ID=329

>Hi,
> I have an application in which I need to send an e-mail to a certain person. The e-mail part is ok, but what I would need now is to create an file in excel format, that would be sent as an attachment. If it's not possible i can always format my e-mail to have all the informations they needed, but it would be preferable to do it with an excel file... Is there any way to do it and if yes, how can we do this?