MSAccess applicationerror after sending an object to Lotus Notes

[djjesp]

Hi there,
I'm getting an MSAccess applicationerror after sending an object to the Lotus Notes mailaccount.
My code is as follows:
DoCmd.SendObject acSendQuery, "query", acFormatXLS, toAddress, , , subject)

Lotus notes opens correctly, the xls-file is created correcty and the subject is coming through correctly.
So not to bad, but the toAddress is not there and even worse after between ten seconds and a couple of minutes I'm forced to close MSAccess because of an applicationerror:'The instruction at 0x0..... referenced memory at 0x00000010. The memory could not be read'

So, anyone knows what's wrong??
Thanks

 

[djjesp]

I tried above with outlook express and that goes fine all the way. So must be a problem between Access and Notes. Maybe I'm missing a reference?

 

[djjesp]

maybe a PC system failure?

Anyone??

 

[oharab]

Yup, it's notes.
IIRC Lotus notes doesn't open itself to the MAPI properly, so it dies a death.
However, don't dispair.
Have a look at thread181-310363 where I give the code to do exactly what you want. Using this code you can just send an email to whomever you want.
If you want to send a query with it, you will have to export it first, then attach the file, but nothing too strenuous.

Let me know if you need more help.

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[djjesp]

Ben,

That was what I was looking for. I gave it a bit more functionality, like automatic opening of Notes, CCC and BCC sending, but it showed me the way,
Thanks

Jeroen