How do you create the functionality Send To Mail Recipient in your app using Outlook 2000

Hi,

I want my app the ability to send an email to a mail recipient with a file attachment. This can be seen in Excel 2000. It opens up a dialogbox with the file you are currently working on as attachment. In a form where I have a datagrid diplaying a recordset, I have code to save it to an excel sheet. I would like to have the ability to email it instead of saving it. How can this be done using the Excel objects?

oops, should be Excel.... I was thinking may be it should be done in Outlook, so I mistakenly put it in the subject line.

Thxs

RF