Office Hack Series 1 : Forgot to mention subject in Outlook mail???
Scenario : You use Microsoft Outlook for your official correspondence. But you keep forgetting to add Subject to your mails. How do you overcome that ??
Solution : Yes…. It’s a concern for all. A mail without a subject creates a bad impression and makes us appear Unprofessional. So how do you avoid this.
To avoid this, just follow the simple steps mentioned below : –
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)Dim strSubject As StringstrSubject = Item.SubjectIf Len(Trim(strSubject)) = 0 ThenPrompt$ = “Subject is Empty. Are you sure you want to send the Mail?”If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, “Check for Subject”) = vbNo ThenCancel = TrueEnd IfEnd IfEnd Sub