Send e-mail - disable security warning

[danka]

Hello:

When I use Outlook object in my application with item.send I get Outlook
security warning message and user needs to press yes or no key. I am running
this from a client Outlook - or can I use some form of send keys from VBA so
it would select Yes.
This message is: "A program is trying automatically send e-mail on your
behalf (it is my legitimate application that is sending it). ...etc.?

Thanks for your assistance.

 

[Dirk Goldgar]

Hello:

When I use Outlook object in my application with item.send I get
Outlook security warning message and user needs to press yes or no
key. I am running this from a client Outlook - or can I use some
form of send keys from VBA so it would select Yes.
This message is: "A program is trying automatically send e-mail on
your behalf (it is my legitimate application that is sending it).
...etc.?

You'll find some workarounds for that on this page:

http://www.granite.ab.ca/access/email/outlook.htm

 

[danka]

Hello Dirk:

Thanks for your response. I am still wondering if there is anything I can
write in VBA code inside access. Third party programs usually run in a
system tray, need to be installed on all the machines and it is hard to say
how they operate.

Are there any other solutions availalable to supress the window?

 

[Dirk Goldgar]

Hello Dirk:

Thanks for your response. I am still wondering if there is anything
I can write in VBA code inside access. Third party programs usually
run in a system tray, need to be installed on all the machines and it
is hard to say how they operate.

Are there any other solutions availalable to supress the window?

If you use the Redemption library, I don't think there'll be anything
running in the system tray. However, it would have to be installed with
your application, AFAIK.

You could presumably do in VBA code what ClickYes does -- watch the
sysem for the appearance of the security prompt and send it the
appropriate message. But you'd have to write the necessary
window-handling code yourself. I don't know the details of what is
involved.

Or you could use a mechanism other than Outlook to send your mail. You
may be able to use CDO, or your own SMTP module. However, then your
messages won't appear in Outlook's message stores, which may be a
drawback. If you don't strictly require Outlook, see the other
alternatives listed at

http://www.granite.ab.ca/access/email.htm

especially

http://www.granite.ab.ca/access/email/winsock.htm