Macro to prompt user to check Subject when send button is clicked

Hi

I am trying to come up with a code in excel vba that will prompt use to double check the subject when "Send"
is clicked.

The code i have below is for Outlook vba and will only prompt when the Subject is empty

Is it possible to edit the below so that i can use it in excel and have it to prompt when "Send" is clicked. Thank you

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 "You are not allowed to send an item with a blank subject. Please enter a subject and send again.", vbCritical + vbOKOnly, "Prevent Blank Subjects" Cancel = True End IfEnd Sub

Hi, be sure to use code tags when posting code. Does the subject need to contain any special words?

You could try something like this at the beginning of your code....

Please Login or Register  to view this content.