How to Prevent blank outlook subject lines

Posted on 2012-08-29
Last Modified: 2012-09-03
I found a post on how to stop a user from sending a blank subject line (code below) however, when the user opens outlook it warns them to disable macros.  I don't want the users to know I've added this code so my question is how do I stop the macro warning when they first open outlook?  I've attached the warning.

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
    If Item.Subject = "" Then
        'Edit the message and the popup caption on the next line as desired.'
        MsgBox "Emails cannot be sent with a blank subject.  Please enter a subject and send again.", vbCritical + vbOKOnly, "Blank Subjects"
        Cancel = True
    End If
End Sub
Question by:jrsitman
    LVL 28

    Accepted Solution

    You can use SelfCert to sign the macro so it will be trusted.  See this article for instructions

    OM Gang

    Author Comment

    ok, the article looks good and simple.  I need to figure out how to give the users access to the Microsoft Tools, because they are using Citrix and have restricted access.  I'll work on it.
    LVL 47

    Expert Comment

    OUtlook 2010 has built in Functionality that Causes a POP UP window if a user creates an email and goes to send it
    They would receive an Pop Up that states

    "Do you want to send this message without a subject?"
    Dont Sent   /   Send Anyway

    They have to actaully select send anyway for it to be sent

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Set OWA language and time zone in Exchange for individuals, all users or per database.
    Use email signature images to promote corporate certifications and industry awards.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    760 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

    6 Experts available now in Live!

    Get 1:1 Help Now