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 CodeRelated Templates
More VBA templates in the same category