Emailing from Access

[Guest]

I'm using DoCmd.SendObject to send an email from Access. The mail goes
through but the problem is Outlook gives a warning message. Isn't there a way
to disable that message?

 

[Rick Brandt]

I'm using DoCmd.SendObject to send an email from Access. The mail goes
through but the problem is Outlook gives a warning message. Isn't
there a way to disable that message?

Basically by not using Outlook. It is Outlook's security that is raising the
message, not Access.

There is a product called Redemption and you can use CDO (built into Win2K and
WinXP) as alternatives.

 

[Guest]

Wromee there are a couple of option available to you:

1. Check out http://www.slipstick.com/outlook/esecup.htm there you will find
a couple of utilities that can automatically press the OK/Yes button so you
don't have to. Check out the Outlook redemption section amongst other things.

2. I personally decided to use a freeware program called 'blat' to send mail
from access, avoiding the entire issue altogether. If you are interested you
can get a copy at http://www.sourceforge.net

Hope this help,

Daniel