sendobject and Lotus Notes

[maryj]

Hello all,
I have created a macro using sendobject that will take an Access report and send it to a Lotus Notes email in the snapshot format. The macro works fine the first time. But after that, it sends the report in an Excel format. The Msoft Knowledge Base 555020 addresses this. After the temp file is deleted, the macro again works, once. Then the temp file is recreated. Any ideas how to prevent the temp file from being recreated??

 

[Norie]

You can use the Kill <filename> statement to delete any file.

You would obviously need to know the filename and path. Perhaps you could incorporate that in your code?