Real understanding of the Docmd.SendObject acSendNoObject

[gerard1979]

I use the rule Docmd.SendObject acSendNoObject for running a daily/weekly automated emailsession. I run it from the AutoForm_Load event with a macro. This give no troubles but what happens exactly with the command?
The problem is: sometimes, totally random, when an user start the program at first on a day (the moment the code is running), he gets a OLE/DDE failure and the emails will not be sent. This is very irritating, because the emails handle information what's neccesary for the users.
Is this a problem from Outlook/Access/a combination of both. I'm not an Outlook-expert so I haven't any idea what happens. I know there is a way to run emails straight from Outlook with Dim appOutlook as New Outlook.Application and so on. But it's much hardcoded old VBA to change so I hope I can handle the problem with some error trapping. I don't know the number of the error because I NEVER SEEN IT BY MYSELF!!! everytime I run the code it's ok!

Any help appreciated,

Thnx in advance,
gerard

 

[KenReay]

Hi

Only of indirect help, but why not put in an error trap, to dispaly the error number, and ask your user to relay it to you, if user cannot be trusted to do this, write it to a table or test file so that you can examine it at your leisure?
Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use