In Microsoft Outlook, you can easily send a schedule recurring appointment, meeting or task to others. But if you just want to send a schedule recurring email without any appointment, meeting or task, how can you do? Unfortunately, Outlook provides no feature for sending schedule recurring email, but in our tutorial, we will show you how to send a schedule recurring email with or without attachments in Outlook.
5 Steps total
Step 1: Create a new appointment
1. Please navigate to the Calendar view by clicking Calendar in the Navigation Pane, and then create a new appointment by clicking New Appointment under Home tab.
2.. In the Appointment dialog under Appointment tab. You need to:
2.. In the Appointment dialog under Appointment tab. You need to:
A: Type in the Subject
B: Enter the recipients’ email addresses in the Location (email must be enclosed between "<>" and separated by ";")
C: Configure the Start time and the End time
D: Select the reminder under the Reminder drop-down list.
If you choose 15 minutes, it means it will remind you 15 minutes early when the email is sent.
E: Compose your Appointment body.
B: Enter the recipients’ email addresses in the Location (email must be enclosed between "<>" and separated by ";")
C: Configure the Start time and the End time
D: Select the reminder under the Reminder drop-down list.
If you choose 15 minutes, it means it will remind you 15 minutes early when the email is sent.
E: Compose your Appointment body.
Note: The Appointment Subject will become the recurring email subject; and the Appointment body will become the recurring email body when the recipients received the email.
Step 2: Create a new category
Now you need to create a new category named “Send Schedule Recurring Email” as follows:
1. In the Appointment dialog, please click Categorize > All Categories in the Tags group under Appointment tab.
2. When the Color Categories dialog popping up, please click New button. In the Add New Category dialog, type “Recurring Email” in the Name field; and then choose a color in the Color drop-down list. Then click OK.
3. Then you will see the “Recurring Email” category is listed out, please check the box, and then click OK button.
2. When the Color Categories dialog popping up, please click New button. In the Add New Category dialog, type “Recurring Email” in the Name field; and then choose a color in the Color drop-down list. Then click OK.
3. Then you will see the “Recurring Email” category is listed out, please check the box, and then click OK button.
Step 3: Set the Recurrence
Now, it is time to set the recurrence for the appointment.
1. Click Recurrence in the Options group under Appointment tab.
2. In the Appointment Recurrence dialog, configure your Recurrence pattern. If you need an end time, please configure it under Range of recurrence. And then click OK.
3. When it returns to the Appointment dialog, please click Save & Close button.
2. In the Appointment Recurrence dialog, configure your Recurrence pattern. If you need an end time, please configure it under Range of recurrence. And then click OK.
3. When it returns to the Appointment dialog, please click Save & Close button.
Step 4: Use the VBA code for sending the Schedule Recurring Email
1. Please press Alt + F11 to open the Microsoft Visual Basic for Applications dialog.
2. Double click on Project1 > Microsoft Outlook Object > ThisOutlookSession in the left pane.
3. Copy and paste the following VBA code (below) to the VBA editor. And then click Save button.
2. Double click on Project1 > Microsoft Outlook Object > ThisOutlookSession in the left pane.
3. Copy and paste the following VBA code (below) to the VBA editor. And then click Save button.
Private Sub Application_Reminder(ByVal Item As Object)
Dim objMsg As MailItem
Dim objApp As AppointmentItem
Dim Att As Attachment
Dim tmpFolder As String
Dim filePath As String
Set objMsg = Application.CreateItem(olMailItem)
If Item.MessageClass <> "IPM.Appointment" Then
Exit Sub
End If
If Item.Categories <> "Recurring Email" Then
Exit Sub
End If
tmpFolder = Environ("TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.To = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
End Sub
Dim objMsg As MailItem
Dim objApp As AppointmentItem
Dim Att As Attachment
Dim tmpFolder As String
Dim filePath As String
Set objMsg = Application.CreateItem(olMailItem)
If Item.MessageClass <> "IPM.Appointment" Then
Exit Sub
End If
If Item.Categories <> "Recurring Email" Then
Exit Sub
End If
tmpFolder = Environ("TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.To = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
End Sub
Step 5: Enable Macros
You must enable the Outlook macros.
Step 1: Click the File > Options.
Step 2: In the Outlook Options dialog box, click the Trust Center in the left bar.
Step 3: Click the Trust Center Settings button.
Step 4: In the Trust Center dialog box, click the Macro Settings in the left bar.
Step 5: In the Macro Settings section:
To enable all macros, please check the Enable all macros (not recommended; potentially dangerous code can run) option.
To disable all macros in your Microsoft Outlook, please uncheck the Enable all macros (not recommended; potentially dangerous code can run) option.
Step 2: In the Outlook Options dialog box, click the Trust Center in the left bar.
Step 3: Click the Trust Center Settings button.
Step 4: In the Trust Center dialog box, click the Macro Settings in the left bar.
Step 5: In the Macro Settings section:
To enable all macros, please check the Enable all macros (not recommended; potentially dangerous code can run) option.
To disable all macros in your Microsoft Outlook, please uncheck the Enable all macros (not recommended; potentially dangerous code can run) option.
Step 6: Click OK buttons in each dialog box.
Step 7: Restart your Microsoft Outlook 2010 or 2013 to activate it.
Step 7: Restart your Microsoft Outlook 2010 or 2013 to activate it.
When the Reminder popping up, the email will be automatically sent to the recipients which you have typed in the Location field in the first part. Then click Dismiss in the Reminder dialog. And the email will be sent recurring every day in this time.
Microsoft document link: https://docs.microsoft.com/en-us/office/vba/api/outlook.mailitem
