Sending Email from Access

M

ML

I am able to create a macro to send an email message to my users, but how can
I populate the "To" field automatically? My user's email address is included
on the query/report I run, and I would like to be able to send that
query/report automatically just to the users specified by the query criteria.
Is this possible?
 
M

ML

Thanks fellas...I'll give it a try!

Arvin Meyer said:
You need a form to run the code to send an email. You can use the same form
that you use to open the report. For one easy code solution look at
"SendObject" in your help files. An example is at:

http://www.datastrat.com/Download/EmailSenate2K.zip

If you're using Outlook, here's some Outlook code that works great:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Click to expand...
 
A

Arvin Meyer [MVP]

A FREE program which disables all, email security warnings, including those
from Outlook Express is available at:

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

I've used it successfully to ward off the problem security warning when
automatically sending as many as 1200 individual emailed purchase orders at
a time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:%[email protected]...
 
A

Andrei Smolin [Add-in Express]

Hello Arvin,
A FREE program which disables all, email security warnings, including those
Click to expand...

You are wrong. On http://www.dimastr.com/redemption/home.htm, I see that
Redemption isn't free.

Both Redemption and Security Manager
(http://www.add-in-express.com/outlook-security/) support Extended MAPI,
Simple MAPI (Outlook Express), and CDO. That is, the most obvious difference
is in their usage: with Security Manager you write actually four lines of
VBA code if your app uses any of these technologies (dim, set, turn security
off, turn security on), with Redemption you use Redemption objects instead
of Outlook ones, Redemption objects instead of CDO ones, etc. Which way you
prefer is up to you.


Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
We are at www.add-in-express.com

Arvin Meyer said:
A FREE program which disables all, email security warnings, including those
from Outlook Express is available at:

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

I've used it successfully to ward off the problem security warning when
automatically sending as many as 1200 individual emailed purchase orders
at a time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:%[email protected]...
To avoid security warnings, see "Disable Outlook security warnings when
sending email messages in MS Access" at
http://www.add-in-express.com/creat...ty-warnings-sending-email-messages-in-access/.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Click to expand...
Click to expand...
 
M

ML

I have been playing with your form this morning, and have another question.
I do not want to have to select the users to send my email report to...that
list box is populated by a query that includes everyone I want to send the
report to. Is there a way to do that? Thanks again!
 
M

ML

Never mind, I figured it out. In the Open event for the form, I simply set
the Selected property for all items in the ListBox to True.
 
A

Arvin Meyer [MVP]

It is absolutely free to individuals and cost $200 for an enterprise wide
license for corporations or for redistribution of code.

IOW, if he distributes his product, he needs to buy a license. I've been
using Redemption for years and can vouch for the quality of the product and
support. And BTW, you do not need to write any code with Redemption, merely
installing it suppresses the security messages. Using Redemption objects is
only necessary for extended email capability.

I have not had a chance to test your product so I cannot attest to it's
quality, but the Outlook MVPs that I know have been recommending Redemption
for the last 4 or 5 years that the security warnings have been in effect.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:[email protected]...
Hello Arvin,
A FREE program which disables all, email security warnings, including
those
Click to expand...

You are wrong. On http://www.dimastr.com/redemption/home.htm, I see that
Redemption isn't free.

Both Redemption and Security Manager
(http://www.add-in-express.com/outlook-security/) support Extended MAPI,
Simple MAPI (Outlook Express), and CDO. That is, the most obvious
difference is in their usage: with Security Manager you write actually
four lines of VBA code if your app uses any of these technologies (dim,
set, turn security off, turn security on), with Redemption you use
Redemption objects instead of Outlook ones, Redemption objects instead of
CDO ones, etc. Which way you prefer is up to you.


Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
We are at www.add-in-express.com

Arvin Meyer said:
A FREE program which disables all, email security warnings, including
those from Outlook Express is available at:

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

I've used it successfully to ward off the problem security warning when
automatically sending as many as 1200 individual emailed purchase orders
at a time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:%[email protected]...
To avoid security warnings, see "Disable Outlook security warnings when
sending email messages in MS Access" at
http://www.add-in-express.com/creat...ty-warnings-sending-email-messages-in-access/.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader

You need a form to run the code to send an email. You can use the same
form that you use to open the report. For one easy code solution look
at "SendObject" in your help files. An example is at:

http://www.datastrat.com/Download/EmailSenate2K.zip

If you're using Outlook, here's some Outlook code that works great:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am able to create a macro to send an email message to my users, but
how can
I populate the "To" field automatically? My user's email address is
included
on the query/report I run, and I would like to be able to send that
query/report automatically just to the users specified by the query
criteria.
Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:[email protected]...
Hello Arvin,
A FREE program which disables all, email security warnings, including
those
Click to expand...

You are wrong. On http://www.dimastr.com/redemption/home.htm, I see that
Redemption isn't free.

Both Redemption and Security Manager
(http://www.add-in-express.com/outlook-security/) support Extended MAPI,
Simple MAPI (Outlook Express), and CDO. That is, the most obvious
difference is in their usage: with Security Manager you write actually
four lines of VBA code if your app uses any of these technologies (dim,
set, turn security off, turn security on), with Redemption you use
Redemption objects instead of Outlook ones, Redemption objects instead of
CDO ones, etc. Which way you prefer is up to you.


Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader
We are at www.add-in-express.com

Arvin Meyer said:
A FREE program which disables all, email security warnings, including
those from Outlook Express is available at:

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

I've used it successfully to ward off the problem security warning when
automatically sending as many as 1200 individual emailed purchase orders
at a time.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Andrei Smolin [Add-in Express]" <andrei dot smolin @ add-in-express
dot_com> wrote in message news:%[email protected]...
To avoid security warnings, see "Disable Outlook security warnings when
sending email messages in MS Access" at
http://www.add-in-express.com/creat...ty-warnings-sending-email-messages-in-access/.

Regards from Belarus (GMT+2),

Andrei Smolin
Add-in Express Team Leader

You need a form to run the code to send an email. You can use the same
form that you use to open the report. For one easy code solution look
at "SendObject" in your help files. An example is at:

http://www.datastrat.com/Download/EmailSenate2K.zip

If you're using Outlook, here's some Outlook code that works great:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I am able to create a macro to send an email message to my users, but
how can
I populate the "To" field automatically? My user's email address is
included
on the query/report I run, and I would like to be able to send that
query/report automatically just to the users specified by the query
criteria.
Is this possible?
Click to expand...
Click to expand...
Click to expand...
 
E

el hajji el mighouar

Arvin Meyer said:
You need a form to run the code to send an email. You can use the same
form that you use to open the report. For one easy code solution look at
"SendObject" in your help files. An example is at:

http://www.datastrat.com/Download/EmailSenate2K.zip

If you're using Outlook, here's some Outlook code that works great:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Click to expand...
 
Top