Solved

Suppressing warnings when using DoCmd.SendObject acSendNoObject

Posted on 2004-04-20
10
1,551 Views
Last Modified: 2007-12-19
I'm working on an Access 97 database and I have a script that sends out e-mails thru Outlook 2002 using DoCmd.SendObject acSendNoObject.

When it attempts to send, I get the message:
  A program is trying to automatically send e-mail on your behalf.
  Do you want to allow this?
  If this is unexpected, it may be a virus and you should choose "No".

I'm trying to find how to prevent Outlook from displaying this warning for every message that the script tries to send.

Can somebody help with this?

Thanks

~Rob
0
Comment
Question by:rfiddler
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 14

Accepted Solution

by:
JohnK813 earned 25 total points
Comment Utility
You probably have 2 options:

1. Place the command 'DoCmd.SetWarnings False' right before your SendObject.  I don't think this works in this case, though, so you can use
2. CDO, if you're on an Exchange server (or use any other SMTP server, I believe).

CDO is explained (more or less) here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_olemsg_overview_of_cdo.asp

but it's better understood through an example.  Let me know if you'd like to go this route and I'll try to find some sample code to post.
0
 

Author Comment

by:rfiddler
Comment Utility
Thanks John, but I've tried both of those routes.

'DoCmd.SetWarnings False' doesn't seem to affect it, and I could do it with CDO, but it's not an option to have an SMTP server running on the workstation that is running the database.

Is there any other way besides these two?

Thanks for your help
0
 
LVL 10

Assisted Solution

by:perkc
perkc earned 25 total points
Comment Utility
This was a Microsoft security update. The following link has some options:

http://www.experts-exchange.com/Databases/MS_Access/Q_20301365.html

perkc
0
 

Author Comment

by:rfiddler
Comment Utility
perkc: The answers they provided at http://www.experts-exchange.com/Databases/MS_Access/Q_20301365.html all seem to be about CDO again.
I can't use CDO because the database is running on a workstation without a SMTP service installed.

Or is it somehow possible to send e-mails without a SMTP service installed?
0
 
LVL 1

Expert Comment

by:dssdb
Comment Utility
This free utility solves the problem:

http://www.express-soft.com/mailmate/clickyes.html
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:rfiddler
Comment Utility
Yeah I've come across that one.. unfortunately they don't want any other software installed on the workstation.

Does this mean that it's not possible to stop that warning?

Thanks
0
 
LVL 14

Expert Comment

by:JohnK813
Comment Utility
I think, under your conditions (Outlook, no CDO, no other software), it may not be possible to supress the warnings.  I could be very wrong, so you may wish to leave this open for a few days.

I'd also suggest placing a pointer question in Apps -> MS Office -> Outlook, to see if anyone there knows anything about this.
0
 
LVL 10

Expert Comment

by:perkc
Comment Utility
The clickyes program that was suggested on the link I posted is the only non cdo method that I've heard about. Another option would be to reinstall Office/Outlook and not install the security update.

perkc
0
 

Author Comment

by:rfiddler
Comment Utility
Thanks for your help guys.
0
 

Author Comment

by:rfiddler
Comment Utility
I've split the points and selected the first comments as the answer because I don't know which of these is applicable.. every comment is an answer but unfortunately I can't use any of those methods.  :(

Thanks again.

~Rob

dssdb: In case you're wondering about it, that clickyes link is also under the link that perkc posted in a previous comment - I gave him the points because he was first.  Thanks for your help though.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now