• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • Last Modified:

How to Prevent blank outlook subject lines

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
J.R. Sitman
J.R. Sitman
  • 2
1 Solution
You can use SelfCert to sign the macro so it will be trusted.  See this article for instructions

OM Gang
J.R. SitmanAuthor Commented:
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.
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
J.R. SitmanAuthor Commented:

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now