Send object error

[Tim]

I have a report in an Access database that I wish to mail
to the interested parties once a week. I'm trying to
automate this using a macro and the 'Send Object' method.


I have tried different fomats for doing this.
Upon running the macro, a quick splash comes up showing
that the report is 'printing' (more correctly outputting
to file), then I get an error message that my lotus notes
mail file does not exist

Switching back into Access, and there's a lotus
notes 'MailMan' message saying the file does not exist
.. Clicking OK to get rid of it results in this message

before finally bringin up the 'Action Failed' dialogue in
Access.

Not wanting to jump to too many conclusions from the off,
but am I asking too much from the outset for MSAccess and
Lotus Notes to work well with each other?

TIA
Tim

 

[Bill Johnson]

No help from me except to say I'm on here for the exact
same reason.

Lotus Notes and Access SendObject... is there a work -
around?

 

[Bill Johnson]

I found a fix for this problem.

In one of the error messages you receive, you'll get a
message that tells you the file doesn't exist. Write
down the name of the folder that is given in that
message. In my case it was /mail04.

At this point I'll have to assume that Notes is set up on
your computer the same as mine, you'll have to create
a "mail04" folder under... C:\Lotus\Notes\Data\

Copy your user file (username.nsf)from the Data directory
into the new "mail04" directory and try your macro again.