E-Mail A Report

T

Tony Ramirez

Hi,

I am trying to have my night process in Access kick a report to someone.
When I run the macro using the SendObject command a window pops up from
Microsoft Office Outlook asking if its okay to send this. Anyway you know to
bypass this and have Access automatically send an e-mail without approval.

Thanks
 
R

Ron2006

That is part of the security change that MS put in a while back. If
you search on outlook security in these groups - particularly the
Access (only) group a number of outside solutions have been offered.

Here is a solution that was proposed a while back:

http://www.contextmagic.com/express-clickyes/


Express ClickYes vs. ClickYes Pro. Which one suits you better.
ClickYes Software is your helping hand in solving issues caused by
these Outlook warnings. There are two versions available at the
moment: Express ClickYes and ClickYes Pro.

Both of them work in the background. You will hardly ever remember of
ClickYes once it was installed and configured. Both of them are for
allowing your email application work without any delays. But though
they are very similar by name, they are completely different from each
other by design.

While Express ClickYes just clicks the Yes button on behalf of you,
ClickYes Pro configures Outlook security settings and prevents the
Outlook security prompts from appearing at all.

The table below answers the questions asked most frequently. It will
help you to decide which ClickYes version suits you better.
Question ClickYes Pro Express ClickYes
Does it eliminate the annoying Microsoft Outlook security warnings?
Yes Yes
Can I control when the software is active or inactive? Yes Yes
Does it allow to configure which programs can access Outlook address
book or send emails using Outlook? Yes No
Does it work when the workstation (server) is locked or a password-
protected screen saver is running? Yes No
Does it work under Windows Terminal Services or Citrix environment?
Find out more on Server Edition here... Yes No
Does it allow to send emails immediately without 5-second delay (for
Outlook 2003)? Yes No
What Microsoft Outlook versions is it compatible with? 2000
2002
2003
2007 2000
2002
2003
- Why should I take your word for it?
- No, you should not. Just download the software, and give it a try on
your computer completely free of charge. Download
free
trial Download
free
version
Okay. How much does it cost? See prices here... $0
Where can I learn more about this software? Find out more... Find out
more...

=============================================
Here is another one:
=============================================
http://www.dimastr.com/redemption/

What is Outlook Redemption?

Outlook Redemption works around limitations imposed by the Outlook
Security Patch and Service Pack 2 of MS Office 98/2000 and Office
2002/2003/2007 (which include Security Patch) plus provides a number
of objects and functions to work with properties and functionality not
exposed through the Outlook object model.

As of version 4.0, Redemption library also includes the RDO
(Redemption Data Objects) family of objects that can function as a CDO
1.21 replacement.

With Outlook Redemption you can

Make your code run unaffected by the Security Patch.
Access properties not exposed by the Outlook Object Model (internet
message headers, sender e-mail address and hundreds more properties)
Display Address Book.
Directly access RTF body of any Outlook item
Import MSG, EML (RFC822) and TNEF files
Export messages to the MSG, EML, TXT, HTML, TNEF and vCard formats.
Access and manipulate Outlook accounts (Outlook 2002 and above, RDO
library)
Create, access and manipulate MAPI profiles and accounts (Profman
library)
Access MAPI stores (not exposed in the Outlook Object Model at all)
Directly access message attachments as strings or as arrays without
saving them as files first
And much, much more!
Redemption supports Outlook 98, 2000, 2002, 2003 and 2007 (Outlook 97
is not supported by the Safe*Item objects). The RDO family of objects
can also be used with the Exchange Server versions of MAPI.


Using Outlook Redemption

Please follow and carefully read the links below before using Outlook
Redemption.

Redemption objects providing access to the properties, functions and
objects blocked by the Outlook Security Patch. In addition to
providing the exact replica of the corresponding Outlook objects, some
of these objects have extra properties and methods, such as RTFBody on
all Safe*Item objects, AsString and AsArray on attachments, etc. These
objects are designed to be used alongside your existing OOM or CDO
1.21 code with as few modifications as possible.
RDO (Redemption Data Objects) library is designed to be used as a
complete CDO 1.21 replacement. This family of objects is designed to
be used standalone, but it can of course still be used along with your
existing OOM or CDO code.
Miscellaneous Redemption objects providing access to the Extended MAPI
properties and functionality not available through the Outlook Object
Model.


How Outlook Redemption works

Redemption is a regular COM library; once registered on the system, it
is accessible to any programming language (VB, VBA, VC++, Delphi,
etc). Redemption uses Extended MAPI (which is not affected by the
Security Patch since it is not accessible to the scripting languages)
to duplicate the functionality blocked by the Security Patch. All
Safe*Item Redemption objects have an Item property which must be set
to an Outlook item. Once set, you can access any properties and
methods, both blocked and not blocked. For the blocked properties and
functions, Redemption objects completely bypass the Outlook object
model and behave exactly like Outlook objects with no Security Patch
applied. For the properties and methods not blocked by the Security
Patch, all calls are transparently forwarded to the Outlook object
that you assign to the Item property. With this approach changes to
your code are minimal: you only change the way you declare the
objects, but not the rest of your code that actually accesses both
blocked and not blocked properties and methods.

Contact

If you would like to report a bug or suggest a feature for the future
version of Outlook Redemption, please e-mail us at
(e-mail address removed) . Due to a large number of help requests, higher
priority is given to the registered users' requests. If you have a
support question, please look at the FAQ section first.
=========================

http://www.databasedev.co.uk/send_email.html

=============================================
You might be thinking of the free Express ClickYes
http://www.express-soft.com/mailmate/clickyes.html (although there
are
others as well)
======================================================
I have used a free piece of software called ExpressClickYes. You can
get that from here:
http://www.contextmagic.com/express-clickyes/
======================================================

for $$$$

You should try Redemption.SafeMailItem object
(http://www.dimastr.com/redemption/).

================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top