MAPI in Access, bypass "A program is trying to send e-mail" message

[arniec]

I have Access applications which send out hundreds of e-mails each day. My company's restrictions have made the following rules:

1) We cannot modify our Outlook security to stop the "A program is trying to send e-mail on your behalf" message.
2) We cannot use Redemption
3) We cannot use Express ClickYes

My goal is to develop an Access module which will use MAPI to send e-mail, but a day's worth of googling has not benefited me. The Outlook.Application object produces the same error as the docmd.sendobject command. I know VB has a MAPI object which makes this simple, but Access 2002 VBA does not.

Can anyone give me a starting point? My goal is just to make a generic MAPI module which can then be imported into dozens of databases to provide an easy alternative for us to send e-mails.

Thanks for any help!

 

[PHV]

Have you tried CDO ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[arniec]

Thank you for your post. Since getting it I have been researching CDO but I believe our company has not installed it (and if they do not install it by default we cannot as a rule get it ordered, just like Redemption and ClickYes, we cannot get cooperation, we must work around their rules). I keep seeing references to a Microsoft CDO reference, but it is not in my list nor can I find the appropriate CDO.DLL file.

Any other options I may have?

 

[cghoga]

check this out...

[URL unfurl="true"]http://www.granite.ab.ca/access/email.htm[/url]

hope this helps.

 

[arniec]

Thanks for the link, cghoga. I have looked at many of the links in the Access Email FAQ you posted before posting myself, but didn't see one that fit my specific need. Is there a link in the FAQ that I am missing?

Thanks!!