How to send a schedule recurring email in Outlook?
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 in Outlook.
- First Part: Create a new appointment
- Second Part: Create a new category
- Third Part: Set the Recurrence
- Last: Use the VBA code for sending the Schedule Recurring Email
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.
This tutorial is divided into four parts, you will succeed to send a schedule recurring email after finish these parts. Please do as follows.
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.
3. In the Appointment dialog under Appointment tab. You need to:
|A: Type in the Subject||B: Enter the recipients’ email addresses in the Location|
|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.
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 “Send Schedule 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 “Send Schedule Recurring Email” category is listed out, please check the box, and then click OK button.
Now, it is time to set the recurrence for the appointment.
1. Click Recurrence in the Options group under Appointment tab. See screenshot:
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. See screenshot:
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. See screenshot:
3. Copy and paste the following VBA code to the VBA editor. And then click Save button.
VBA: sending schedule recurring email
Private Sub Application_Reminder(ByVal Item As Object) Dim xMailItem As MailItem On Error Resume Next If Item.Class <> OlObjectClass.olAppointment Then Exit Sub If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub Set xMailItem = Outlook.Application.CreateItem(olMailItem) With xMailItem .To = Item.Location .Subject = Item.Subject .Body = Item.Body .Send End With Set xMailItem = Nothing End Sub
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. See screenshot:
Note: The VBA code was successfully tested in Outlook 2010, 2013 and 2016.
Recommended Productivity Tools
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 13 days agoI got to the VBA code copied, pasted, and saved fine. But no reminder popped up for me to dismiss. Will this still send?
To post as a guest, your comment is unpublished.· 1 months agoIt's great work, tks
To post as a guest, your comment is unpublished.· 1 months agoThis is limited on the number of email addresses you can add in the locations. Any work arounds?
To post as a guest, your comment is unpublished.· 2 months agoThis still works. Just tested on Office 2016/ O365. Make sure macros are enabled. Make sure you are pasting the code under "application" and "Reminder" as shown in the screen shot.
To post as a guest, your comment is unpublished.· 2 months agoI am getting a "compile error: invalid outside procedure" every time ANY reminder pops up, not just the one's for the scheduled send. Also, my scheduled send doesn't work. Any ideas? I copied and pasted the code from above. Thanks.
- ← Previous
- Next →