On Wed, 16 Nov 2005 15:54:20 GMT, Beowulf <be*****************@hotmail.com>
wrote:
ad**************@bbc.co.uk wrote: Hi,
I'm having trouble trying to email a report via access...
I get a Outlook message stating 'a program is trying to automatically
send e-mail on your behalf. Do you want allow this?
This is a "feature" of the newest version of Outlook.
This pop-up did not appear prior to Outlook 2002 (i think).
This report will be emailed in the early hours of the morning when no
users are around to click 'Yes!'Is there a way to prevent this from
happening, so the report gets emailed without user interaction?
There are a couple of work arounds. If these Outlook users are attached
to an Exchange server then the Exachange Admin can turn this prompt off,
if s/he is willing to help you out.
Alternately, if you search Google using the text of the prompt you'll
come across a few utilities that automatically press "Yes" for you.
This is the Google search I used:
Microsoft Outlook "automatically send" email "on your behalf"
Any of these work-arounds could also be used by malicious software, therefore,
if MS continues to be vigilant, these methods will also be thwarted soon. I
believe the best approach will be to stop using Outlook and start using a
tools that is specifically for the purpose of sending e-mail under script
control, such as "blat" (
http://www.blat.net/).
I have used "blat" in the past, and it works very well. You just have to make
sure that, if e-mail is outbound via Exchange Server, the server is set up to
allow SMTP mail forwarding from machines on the internal network (and from
nowhere else, of course). If Exchange Server is not or does not have to be in
the loop, then you don't have to worry about this part.