?
Solved

Bypass Outlook Security

Posted on 2007-07-25
2
Medium Priority
?
454 Views
Last Modified: 2013-12-17
I have an access database that sends out automated emails.  I have to upgrade it to Office 2003.  With that comes Outlook security patch to prevent automated emails.  I need a way around it WITHOUT using any of the following: SMTP, Redemption, Click-Yes or any third party software.  It pretty much needs to be stictly code or something that will work with what little options I have. The machine is Windows Server 2003 and I have Exchange 2003. I'm not sure what other information is helpful, but if needed, just ask.  I'll give whatever I can.  Here is the code that's being used so far.  I didn't create it, and I don't really know anything about this whole programming thing.

Public Function TEST()

On Error GoTo ErrorHandler

Dim MyOutlook As Outlook.Application
Dim MyMail As Outlook.MailItem
Dim Subjectline As String
Dim MyTime
Dim MyDay
Dim MyEOM

MyTime = Format(Now, "Long Time")
MyDay = Format(Date, "dddd")
MyEOM = Format(Date, "d")


        Subjectline$ = "Automated Email" & " " & Date
        Set MyOutlook = New Outlook.Application
        Set MyMail = MyOutlook.CreateItem(olMailItem)
        MyMail.Recipients.Add "RECIPIENT1"
        MyMail.Subject = Subjectline$
        MyMail.Body = "SUBJECT OF MESSAGE GOES HERE"
        MyMail.Send
        Set MyMail = Nothing
        Set MyOutlook = Nothing

ErrorHandler:

Resume Next

End Function
0
Comment
Question by:agent418
2 Comments
 
LVL 20

Accepted Solution

by:
Serena Hsi earned 1000 total points
ID: 19569745
This might help you. I found this on MSDN (Microsoft's developer network):

Avoiding Excessive Security Warnings when Sending Automated E-mail Messages
http://msdn2.microsoft.com/en-us/library/Aa168346(office.11).aspx

Using Automation in Microsoft Office Access 2003 to Work with Microsoft Office Outlook 2003
http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

An article about Outlook "object model guard" security issues:
http://www.outlookcode.com/article.aspx?id=52

Hope these help.
0
 

Author Comment

by:agent418
ID: 19570260
Thank you for your input.  However, I need a much simpler and easier solution.  Unfortunately if the company allowed use of third party software, I wouldn't be in this perdicament.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

839 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