Emailing from MS Access 2000 DB through Lotus Notes

[plshelpme]

is this even possible?

this simple piece of code in Access (where Receiver is a variable containing the email address that I want to send the message to, it is pulled from an Access table)

DoCmd.SendObject , , , Receiver, , , "This is a test."

keeps hitting the error section and gives this output msg:

"The SendObject action was cancelled"

Any Ideas???

Thnx

 

[lameid]

Try...
DoCmd.SendObject , , , Receiver, , , "This is a test.",,False

 

[plshelpme]

no luck. still the same problem.
what about using another language (ie. vbscript) to pull the information from the DB and then compose the personalized emails and send them out using the CDONTs.

any other ideas???

 

[huggybear]

I can't offer you any help but I can tell you that I am also interested in this topic. It seems to be a recurring question and so far I haven't seen a clear solution using Access by itself.

Bear