Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook Security and Access XP 1

Status
Not open for further replies.
LonnieJohnson

LonnieJohnson

Programmer
Apr 16, 2001
2,628
US
I am sending emails programmatically from AccessXP and Outlook is
giving me the message that someone is trying to send a message. It is the
security feature that is looking for spam and viruses.

I was wondering if any of the Gurus out there had code to either....

1. Bypass the Outlook Security

or

2. Send maild directly to a receipiant without going through Outlook.

Thanks in advance.



ProDev, MS Access Applications
Visit me at ==> Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!
 
Sort by date Sort by votes
There's an option that you have to check under Outlook's Options that says "Notify me when other programs are trying to send mail," or something to that effect. Uncheck that box and it will stop asking you.

There is no programmatical way to uncheck it for the reason that worm-writers use this exact functionality to spread the worm. With the option checked, it asks before mailing everyone in your address book.

So it's there for a reason. You may want to leave it checked.
 
Upvote 0 Downvote
I have a database that runs at night. The application programatically sends emails. There is no one here to click the button. I'm not seeing the option you are speaking of. Which tab is it on?

ProDev, MS Access Applications
Visit me at ==> Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!
 
Upvote 0 Downvote
Blah, that was Outlook Express which has that feature. Sorry.

I just googled, and it turns out there is a way, though it's somewhat tougher. Check this web site, which says "...you can turn the Security messages on/off with the Outlook Security Features Administrative Package"

about halfway down the page, in a section titled Outlook Security Patch in Outlook 98, 2000 SP-2 and Outlook 2002

He has a bunch of other good tips for that specific problem.
 
Upvote 0 Downvote
By far the easiest solution...

Uninstall Office XP.

Install an Outlook 2000 version before the security updates.

Install office Xp except for Outlook 2002.

As for a more moral solution... I think it involves digitally signing VBA projects. I've never made the time to dig into that. A great Outlook/Exchange site is slipstick.com.

And I remember reading about someone who created an object model that bypasses this stuff. It costs money... I think I read about in one of the Woody's newsletters in the past 12 months... Archives are at I hope this helps. I don't have the time to do the digging myself.
 
Upvote 0 Downvote
Check out OutlookRedemption on It is a third party dll that wraps the ExtendedMAPI calls up in an object model exposed to VB. It comes with a royalty free distribution license if you purchase it. Another good site for Outlook discussions is Good Luck!

Have a great day!

j2consulting@yahoo.com
 
Upvote 0 Downvote
Yeah, I use Redemption, and it's quite good. I definitely recommend you go that route. Also, when you do it, _do_ follow all of the security tips that Dimitry writes about, as that will make your network folks a lot happier.

One of the reasons I like this solution is because it means I don't have to make any mods to the users' machines. Of course, I use batch files to install my datbases, and that makes it really easy to register the dll that you need to register to use Redemption.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
 
Upvote 0 Downvote

This is part of what we use to send from 1 > emails at one time. Without installing additional programs (our IT won't give the OK) it works. We do set a timer for several reasons but this will send it.

.Subject = Esubject
.To = SendTo
.Body = Ebody
.Attachments.Add NewFileName
.Attachments.Add IntFile
.Display 'This opens the e-mail for viewing (no prompt will appear when sent)
' .Send 'This sends without opening the e-mail (you will get the prompt)
End With
Call sSleep(ctime)

SendKeys "%{s}", True 'This sends the e-mail (won't work if you are stepping through)
 
Upvote 0 Downvote
I have the same problem with some Access DB sending via Outlook (Office XP). It's been a while but I found 2 articles on the Microsoft knowledge base.
-There is no way to programmaticaly «pass» that security feature.
-There is a kind of Admin Tool Kit (from Microsoft) that let you identify either a program or a user to be «allowed» to send e-mails.
My request to the network peoples to use that Tool Kit and give either Access or me the rights to send e-mails was denied for security purposes.
If you're patient, you will find those articles.

Good luck
Jojomick
 
Upvote 0 Downvote
I use a freeware program called "ExpressClickYes". What it does is answer "Yes" in the message box that pops up. Seems to work fine.

There's another program that's called "Pushthefreakinbutton" or something similar, but I haven't tried it.

 
Upvote 0 Downvote
Actually there is a way to programatically bypass this with a very user friendly dll called vbSendMail. It's free and very easy to install. The only thing is that it has to be installed on each machine that uses it and it does not show the tacky popup.

ProDev, MS Access Applications
Visit me at ==> Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!
 
Upvote 0 Downvote
Hey Lonnie,

Do you have a link to the vbSendMail dll file you mention?

Have a great day!

j2consulting@yahoo.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
4K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
5K
grnzbra
grnzbra
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
958
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top