P
(PeteCresswell)
I'd like to put up a little app that runs continuously on my PC at a client site
looking for the presence of a semaphore file.
My "real" applications there would then post a semaphore file every time they
wrote to their respective error logs.
The little app, upon seeing a semaphore, would delete it and email the
application's error log to me at my remote email address (i.e. an email account
not on the client's system).
Problem is, the only way I know how to send mail from VBA is via MAPISendMail -
which, in my experience, just posts an outgoing email to the user's default
email client. Somebody still has to open up the email client and click
"Send".
Anybody been here? Have I got it right so far? If so, can anybody point me
in the direction of a proper workaround?
looking for the presence of a semaphore file.
My "real" applications there would then post a semaphore file every time they
wrote to their respective error logs.
The little app, upon seeing a semaphore, would delete it and email the
application's error log to me at my remote email address (i.e. an email account
not on the client's system).
Problem is, the only way I know how to send mail from VBA is via MAPISendMail -
which, in my experience, just posts an outgoing email to the user's default
email client. Somebody still has to open up the email client and click
"Send".
Anybody been here? Have I got it right so far? If so, can anybody point me
in the direction of a proper workaround?