Sending e-kail through Access

  • Thread starter Thread starter Pietro
  • Start date Start date
P

Pietro

HI,

While trying to send emails through access, outlook prompts "A program is
trying to send an email on your behalf. Do you want to allows this"

Does anyone know how to prevent this from happening ?
I'm trying to send several emails at once and its a big nuisance to have to
click yes each time.
I tried to search the web but i could not an easy way,can anybody post
the code here?
 
Pietro said:
HI,

While trying to send emails through access, outlook prompts "A
program is trying to send an email on your behalf. Do you want to
allows this"

Does anyone know how to prevent this from happening ?
I'm trying to send several emails at once and its a big nuisance to
have to click yes each time.
I tried to search the web but i could not an easy way,can anybody
post the code here?
Click to expand...

That prompt is coming from Outlook, not Access, so the only way to not see
it is to not use Outlook as the mechanism to send your mail from Access.

The two most often used alternatives are Redemption (something you install
separately but works pretty much just like Outlook), and CDO (a messaging
library included in all Windows versions since 2000).
 
There are various work arounds.

1. install a program that clicks the yes button for you (for security
reasons I do not recommend this approach, but it does work)
http://www.snapfiles.com/get/clickyes.html

2. use cdo to send your e-mail
http://www.mvps.org/access/modules/mdl0019.htm
http://support.microsoft.com/kb/286431/
http://support.microsoft.com/kb/286430/

3. install redemption
http://www.dimastr.com/redemption/

also worth reading
http://accessblog.net/2006/12/auto-click-yes-to-outlook-security.html as well
as http://www.outlookcode.com/article.aspx?id=52

Tony' pages covers numerous e-mail technics and is worth your while to check
out http://www.granite.ab.ca/access/email.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.
 
Back
Top