Sending Email via MS Access

[Guest]

I have an app which sends an email via vba within Access. To do that, it
assumes the mail profile of the individual logged on and running the app. It
also pops up a box/form which states that it is using the Outlook profile.
That box also requires the user to click the Yes button.

Question: does anyone know how to get that box to either not pop up or have
it default to yes so that the entire process can be automated without user
interface (clicking the Yes button) ??

Thanx in advance ...

 

[Douglas J. Steele]

You need to look into a third-party product like Outlook Redemption
http://www.dimastr.com/redemption/

See http://www.slipstick.com/outlook/esecup.htm for details, and other
alternatives.

 

[Guest]

How does this program work as far as the PC it's installed on vs. the code in
that particular application? I'm asking becasue I would like this as well,
but it's more for all the users who will be sending an email to ME without
their knowledge with input they have provided in the database. If i install
this on MY pc, will it also prevent the users on other PCs from seeing that
message box? Is it a function of my application or particular PC-based?

Thank you,
MN

 

[Baz]

First you need to install Redemption and modify your application to use it
(the modifications from the usual Outlook automation are very simple).
Then, you need to distribute Redemption with your modified application (it
does not have the capability to work telepathically from your PC). This is
not free, to distribute Redemption you need to buy a licence ($200 if I
recall correctly).

 

[jmoss111 via AccessMonster.com]

Bob,

Rather than using redemption or the click Yes utility or who knows what M$
will do to break email functionality in the future, we opted to just use smtp
email

Jim

 

[Rick Brandt]

I have an app which sends an email via vba within Access. To do
that, it assumes the mail profile of the individual logged on and
running the app. It also pops up a box/form which states that it is
using the Outlook profile. That box also requires the user to click
the Yes button.

Question: does anyone know how to get that box to either not pop up
or have it default to yes so that the entire process can be automated
without user interface (clicking the Yes button) ??

Thanx in advance ...

Automate the CDOSys library instead of Outlook.

 

[Guest]

Jim,

How do you go about using SMTP email?

Thanks,
MN

 

[Guest]

Thanks Rick! Do you have some MS Access code snippets using the CDOSys
library for sending email that you would be willing to share?

 

[Guest]

I appreciate the advice Jim. I'm wondering how I would use SMTP in Access to
send email?

 

[Guest]

I would be very iinterested in learning how to use the CDOSys library rather
than outlook as well.

Thanks!
MN