Sendobject

[Eland]

Hi i'm trying to use docmd.sendobject to send a mail.
All works fine ... if in only send one.

If i want to send a second mail. I have to close and reopen my database before i can send anotherone. I don't get any errormessages.
Using access 2000 and outlook 2000.
Found an article that told me messages won't be send when they are too big but that isn't the case.

Does anybody have an idea?

 

[jfgambit]

Can you post the code so that we can review it?

 

[Rob.Mills]

Eland --

There's an error with the SendObject command in A2k. Nothing you can do about it. Best thing I recommend is since you're using Outlook for email you can set that up through code without a problem. Sending an attachment requires an extra step. You have to export to a file and then create the email and attach the file.