S
SHAWN
Guys..Need some help please.
I've got an Access database that is updated every night (bunch of
macros stored in an Excel spreadsheet and triggered by the Task
scheduler).
At the end of an update I want to automatically send email to users
that database has been updated, that many records were deleted,
inserted etc...etc..
The problem I've got is that stupid security box that doesn't allow
email to be sent automatically. I've tried to use CDO but get "The
sendusing value's invalid" message. I've got a minimal knowledge of
CDO so that was a pretty much show stopper.
I also tried to use John Walkenbach's code (using Sendkeys)but it does
not work on a machine that is locked (since the update happens at
night I need to have the machine running, but can't just leave it
without locking for security reasons).
I would REALLY appreciate any suggestions you might have.
BTW, I was told that buying Redemption is not an option for whatever
reason.
Thanks
I've got an Access database that is updated every night (bunch of
macros stored in an Excel spreadsheet and triggered by the Task
scheduler).
At the end of an update I want to automatically send email to users
that database has been updated, that many records were deleted,
inserted etc...etc..
The problem I've got is that stupid security box that doesn't allow
email to be sent automatically. I've tried to use CDO but get "The
sendusing value's invalid" message. I've got a minimal knowledge of
CDO so that was a pretty much show stopper.
I also tried to use John Walkenbach's code (using Sendkeys)but it does
not work on a machine that is locked (since the update happens at
night I need to have the machine running, but can't just leave it
without locking for security reasons).
I would REALLY appreciate any suggestions you might have.
BTW, I was told that buying Redemption is not an option for whatever
reason.
Thanks