Email an excel file from Access

[dunner44]

I am using Microsoft Office 2000. In an Access form, I want to email an Excel file. Here is the code I used...

DoCmd.SendObject acSendNoObject, "U:\Filepath\EcxelSheet.xls", , , , , "email subject"

When it runs, a new Outlook email message pops up, but no object is attached. That is because of the SendNoObject...I think.

Any suggestions?

TIA

 

[HitechUser]

This may be easier.. Example

Hey just an idea.