How to create a drop-down list for subjects in Outlook?

You may have different preset email subjects that need to be distributed to different recipients in Outlook. It would be very efficient to have a subject line drop-down list for selecting a subject without typing it manually when composing an email. Just like the gif demonstrated below. This tutorial provides three VBA codes to help you create a drop-down list with different preset subjects. When composing an email, you can select any subject you need from the drop-down to automatically fill in the subject line. Please follow the step-by-step guide to get it done.

Create a drop-down list for subjects in Outlook with VBA code

Actually, Outlook does not allow to add a drop-down list in the subject line. Here you need to create a user form and combine it with VBA codes to complete it.

1. Launch your Outlook, press the "Alt" + "F11" keys to open the "Microsoft Visual Basic for Applications" window.

2. In the "Microsoft Visual Basic for Applications" window, click "Insert" > "UserForm".

3. Then the "UserForm1" is inserted under "Project1" in the left pane of the "Visual Basic" editor. You need to add a combo box and a command button to this userform by dragging the "ComboBox" and "CommandButton" respectively from the "Toolbox" to the "UserForm1".

4. Right click the command button and select "Properties" in the right-click menu.

5. In the "Properties – CommandButton1" pane, change the "Caption" field to "OK". This action will change the text displayed on the command button.

6. Double click on the blank area in the UserForm to open the corresponding "UserForm (Code)" window, then replace the existing code with the following VBA code.

VBA code 1: UserForm with a drop-down list including multiple preset email subjects

Private Sub UserForm_Initialize()
'Updated by Extendoffice 20220927
  With ComboBox1
    .AddItem "Subject 1"
    .AddItem "Subject 2"
    .AddItem "Subject 3"
    .AddItem "Subject 4"
    .AddItem "Subject 5"
    .AddItem "No change"
  End With
End Sub

Private Sub CommandButton1_Click()
  GCbbIndex = ComboBox1.ListIndex
  GSelSubject = ComboBox1.Value
  Unload Me
End Sub

Note: In the code, the "Subject 1, 2, 3, 4" and "5" are the preset email subjects you want to use in your emails. “No change” means not change anything of the existing email subject. You can change the preset email subjects in the VBA code according to your needs.

7. Double click "Project1" > "Microsoft Outlook Objects" > "ThisOutlookSession". Then copy the following VBA code into the "ThisOutlookSession (Code)" window.

VBA code 2 used in the ThisOutlookSession window

Public WithEvents GExplorer As Explorer
'Updated by Extendoffice 20220927
Private Sub Application_Startup()
  Set GExplorer = Application.ActiveExplorer
End Sub

Private Sub GExplorer_InlineResponse(ByVal Item As Object)
  Set GInlineMail = Item
End Sub

8. Go on clicking "Insert" > "Module" in the "Visual Basic" editor. Then copy and paste the following VBA code into the "Module (Code)" window.

VBA code 3 used in the Module window

Public GCbbIndex As Long
'Updated by Extendoffice 20220927
Public GSelSubject As String
Public GInlineMail As MailItem
Public Sub ChangeSubject()
  Dim xItem As MailItem
  Dim xMail As Outlook.MailItem
  On Error Resume Next
  Select Case TypeName(Application.ActiveWindow)
    Case "Explorer"
      Set xMail = GInlineMail
      Debug.Print "Explorer"
    Case "Inspector"
      Set xMail = Application.ActiveInspector.CurrentItem
      Debug.Print "Inspector"
  End Select
  UserForm1.Show
  If (GCbbIndex <> -1) And (GSelSubject <> "no change") Then
    xMail.Subject = GSelSubject
  End If
End Sub

9. Save the codes and press the "Alt" + "Q" keys to close the "Visual Basic Editor" window and return to Outlook application.

10. Click the "New Email" button under the "Home" tab to create an email.

11. In the new message window, click "Customize Quick Access Toolbar" > "More Commands".

12. In the "Outlook Options" dialog box, you need to configure as follows.

13. Then you can see that a button has been added to the ribbon of the message window.

14. Now you need to restart your Outlook.

15. When composing an email message, if you need to insert a preset subject, you just need to click on the newly added button on the ribbon to display the user form, select a subject from the drop-down menu, and then click the "OK" button to populate it into the subject line.

Notes:

AI Mail Assistant in Outlook: Smarter Replies, Clearer Communication (one-click magic!) FREE

Streamline your daily Outlook tasks with the AI Mail Assistant from Kutools for Outlook. This powerful tool learns from your past emails to offer intelligent and accurate responses, optimize your email content, and help you draft and refine messages effortlessly.

This feature supports:

• Smart Replies: Get responses crafted from your past conversations—tailored, precise, and ready to go.
• Enhanced Content: Automatically refine your email text for clarity and impact.
• Effortless Composition: Just provide keywords, and let AI handle the rest, with multiple writing styles.
• Intelligent Extensions: Expand your thoughts with context-aware suggestions.
• Summarization: Get concise overviews of long emails instantly.
• Global Reach: Translate your emails into any language with ease.

This feature supports:

• Smart email replies
• Optimized content
• Keyword-based drafts
• Intelligent content extension
• Email summarization
• Multi-language translation

Best of all, this feature is completely free forever! Don’t wait—download AI Mail Assistant now and enjoy!

---

Best Office Productivity Tools

Breaking News: Kutools for Outlook Launches Free Version!

Experience the all-new Kutools for Outlook with 100+ incredible features! Click to download now!

🤖 Kutools AI : Uses advanced AI technology to handle emails effortlessly, including replying, summarizing, optimizing, extending, translating, and composing emails.

📧 Email Automation: Auto Reply (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments Pro: Batch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Remind you when important emails come  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Instantly unlock Kutools for Outlook with a single click. Don't wait, download now and boost your efficiency!

Feature List of Kutools for Outlook      Download Now      Go to Purchase