Automaticly sending emails via Outlook from Access

[rogerb]

How can I set up my computer/applications to automatically bypass the
security warnings when programatically sendit Outlook emails from Access.
I'm trying to send bulk mailings to my clients from my own computer.

 

[Geoff]

Roger,

You need to use the Outlook Redemption object library for creating
emails. This is a third-party COM wrapper for Extended MAPI. The
version for your own use is a free download from
http://www.dimastr.com/redemption/ You install the library file on
your hard disc and, in your Access project, create a reference to the
library in the VBA editor (on the Tools, References menu).

For full details on how to use the library, see Sue Mosher's book
"Outlook Programming" on http://www.slipstick.com. Programming
commands in the Redemption library are somewhat different to the
programming commands in the Outlook library.

Be aware that it's not a good idea to by-pass security if you don't
have up-to-date virus protection or firewall (for which see
http://www.zonelabs.com/).

Geoff

 

[Geoff]

I'm posting this reply a second time as the first time it didn't
appear:

Roger,

You need to use the Outlook Redemption object library for creating
emails. This is a third-party COM wrapper for Extended MAPI. The
version for your own use is a free download from
http://www.dimastr.com/redemption/ You install the library file on
your hard disc and, in your Access project, create a reference to the
library in the VBA editor (on the Tools, References menu).

For full details on how to use the library, see Sue Mosher's book
"Outlook Programming" on http://www.slipstick.com. Programming
commands in the Redemption library are somewhat different to the
programming commands in the Outlook library.

Be aware that it's not a good idea to by-pass security if you don't
have up-to-date virus protection or firewall (for which see
http://www.zonelabs.com/).

Geoff

 

[Geoff]

Roger,

You need to use the Outlook Redemption object library for creating
emails. This is a third-party COM wrapper for Extended MAPI. The
version for your own use is a free download from
http://www.dimastr.com/redemption/ You install the library file on
your hard disc and, in your Access project, create a reference to the
library in the VBA editor (on the Tools, References menu).

For full details on how to use the library, see Sue Mosher's book
"Outlook Programming" on http://www.slipstick.com. Programming
commands in the Redemption library are somewhat different to the
programming commands in the Outlook library.

Be aware that it's not a good idea to by-pass security if you don't
have up-to-date virus protection or firewall.

Geoff

 

[Geoff]

Sorry for the repeated messages...

I didn't mean this to turn into a question of my own, but I don't
understand why Outlook Express downloads the header of my reply post
and then, when I try to download my post, I'm told the message has
expired. My repeats were an attempt to understand what was going on.

If anyone has a clue, I'd like to hear. Thanks...

Geoff

 

[Rick Brandt]

You need to use the Outlook Redemption object library for creating
emails. This is a third-party COM wrapper for Extended MAPI. [snip]

Be aware that it's not a good idea to by-pass security if you don't
have up-to-date virus protection or firewall

It has been a standard recommendation to use the Redemption
Libraries to avoid the Outlook security prompts. I just wanted to
interject that it didn't help much in my experience.

Under the latest Outlook/MAPI security models my users experience two
different security prompts when Access attempts to send an Email. There
is the more well known "A program is attempting to send an Email..."
message with the 5 second delayed [OK] button. There is also a somewhat
newer one that says..."A program is attempting to access your Global
Address Book..." This one can be approved or denied immediately and also
has a the option of "Allow for n minutes" where n has several choices
available from a drop-down list.

My testing with Redemption found that while it did prevent the former
prompt, it had zero affect on the second one. While I have never tried it
I assume that the free "auto-click" utility that deals with the first
message might also not work on the second one.