Email Automation Intermediate

Email Template Manager

Manage and use email templates for consistent messaging

14 views

Perfect For:

  • Standardised messaging
  • Template library
  • Quick responses
VBA Code
Sub EmailTemplateManager()
    Dim templateName As String
    Dim emailBody As String
    Dim OutApp As Object
    Dim OutMail As Object

    ' Define email templates
    templateName = InputBox("Enter template name (welcome, followup, reminder):")

    Select Case LCase(templateName)
        Case "welcome"
            emailBody = "Welcome to our service! We are excited to have you on board."
        Case "followup"
            emailBody = "Following up on our previous communication. Please let us know if you have any questions."
        Case "reminder"
            emailBody = "This is a friendly reminder about your upcoming appointment."
        Case Else
            emailBody = InputBox("Enter custom email body:")
    End Select

    ' Create and send email
    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

    With OutMail
        .Subject = "Subject: " & templateName
        .Body = emailBody
        .Display ' Show email for review before sending
    End With
End Sub

Related Topics

email templates consistency management

Need Custom VBA Solutions?

Our AI-powered VBA generator can create custom code tailored to your specific requirements in seconds.

Generate Custom VBA Code

Related Templates

More VBA templates in the same category

Intermediate

Email Automation

Send personalized emails with Excel data

View Template