Automated Email Through Access

[howardjones]

I wonder if anyone can help me with a solution. I need to automatically send Access reports out a specified time to a group of people. I can soert out this part no problem but, I need to know the code to send this through Lotus Notes. Every time I try to invoke this code:

[DoCmd.SendObject acReport, "Report1", "RichTextFormat(*.rtf)", "howard.jones@cis.co.uk", "", "", "Test1", "Test", false, ""]

I get the messege :
Error 2287
Access can't open the mail session

Any help to point me in the right direction would be appreciated

 

[grnzbra]

Why can't you leave the mail session open? If you can't, try running the Shell function and then run the SendObject command.

 

[howardjones]

Cheers your comments are noted, but the mail session is open. I think it is somthing to do with Lotus notes and that it is trying to invoke outlokk instead, we don't use outlook so therefore it is failing. I beleive that there is some code that related to Lotus Notes

If any further ideas they will be appreciated
Thanks Again

 

[nat1967]

Hi Howard,

I am not familiar with Notes but I read this thread the other day. I think it might be of some help.

thread702-92097

HTH Nathan
Senior Test Lead