Some users wish Outlook to auto take the first line of the email body as the subject when sending an email which has no subject. Now, in this article, we will introduce a method to realize it via VBA code.
Multiple users frequently forget to input subject when composing and sending an email. Thus, usually, they hope that Outlook can automatically fill the subject by the first line of the email body if the outgoing email has no subject. Thereinafter, we will share an easy and handy method with you.
Auto Take the First Line of Body as Subject before Sending an Email without Subject
- At the very outset, launch Outlook application.
- Then, by following the steps in “How to Run VBA Code in Your Outlook“, you can get into VBA editor.
- Next, in the VBA editor, add the reference to “MS Word Object Library” with accordance to “How to Add an Object Library Reference in VBA“.
- Later, copy the code below into “ThisOutlookSession” project.
Private WithEvents objInspectors As Outlook.Inspectors
Private Sub Application_Startup()
Set objInspectors = Outlook.Application.Inspectors
End Sub
Private Sub objInspectors_NewInspector(ByVal Inspector As Inspector)
If Inspector.CurrentItem.Class = olMail And Inspector.CurrentItem.Subject = "" Then
Inspector.CurrentItem.Subject = " "
End If
End Sub
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim objMail As Outlook.MailItem
Dim objMailDocument As Word.Document
Dim objMailSelection As Word.Selection
If TypeOf Item Is MailItem Then
Set objMail = Item
If Len(Trim(objMail.Subject)) = 0 Then
If MsgBox("No subject! Whether to take first line as subject?", vbQuestion + vbYesNo) = vbYes Then
Set objMailDocument = objMail.GetInspector.WordEditor
Set objMailSelection = objMailDocument.Application.Selection
objMailDocument.Range(0, 0).Select
objMailSelection.MoveEnd wdLine
'Take first line of body as subject
objMail.Subject = objMailSelection.Text
End If
End If
End If
End Sub
- After that, put cursor into “Application_Startup” subroutine and press “F5”.
- Finally, you can have a try.
- At first, create and compose an email with only subject empty.
- Then, click “Send” button.
- Later, you’ll get a message asking if to take first line of body as subject.
- As long as you select “Yes” button, the first line of the email body will be extracted and used as subject and the email will be sent out.
Keep Your Outlook Data Safe
Absolutely, there are multiple significant emails and other items in your Outlook. Thus, you must be unwilling to come across Outlook data loss. Then, you have to take some actions, such as making regular data backups of your Outlook, learning to use the inbuilt repair tool to fix Outlook errors and preparing a robust external recovery utility. DataNumen Outlook Repair is a good choice due to its high PST recovery rate.
Author Introduction:
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit www.datanumen.com


