Suppose you need to process reports at the end of each month and need data from your co-workers to complete the reports. They always seem to forget, so you need to send them a reminder. How do you automate the process, so they get the reminder automatically?
See Using Microsoft Outlook to Schedule Report Transmissions for a method that uses custom forms. Note that tighter security in Outlook may prevent this from working as expected.
See Delay Sending a Message to delay the sending of a message.
In addition to scheduling recurring messages, the tools on this page can be used to schedule messages to be sent later.
Use Appointment reminders to send recurring message
You can use appointments to trigger a recurring message. In all versions, you can use VBA to send a message when a reminder fires. In older versions that support the online meeting feature, you can use it to open a prepared template and include an attachment.
The VBA method is at Send an email when an Appointment reminder fires. While the sample code contains the message in the appointment body, which is copied to an email message, you can use it to open and send a template instead.
How to use: Create a recurring appointment and set the reminder. When the reminder fires, the macro creates the message and sends it. This method works with Tasks as well.
If you use an older version of Outlook, you can use the online meeting method to open a template. This will not work in Outlook 2007 and up. Unlike the utilities listed in the Tools section, need to press Send to actually send it. It is more "in your face" than a reminder, for those messages you need to schedule but want to edit before sending.
- Create a message and save it as an email template (*.oft)
- Open an meeting invitation (or click the invite button on an appointment) and enter your email address in the To field.
- Add a check to the Online meeting option.
- Select Using Windows Media Services
- Enter the file location of the template in the Event address field Add a check to the field to Automatically start Windows Media with the reminder then Save and close.
When the reminder triggers, a dialog will open, asking if it can open the template. Once opened, press Send.
Tools in the Spotlight
One of the utilities in the MAPILab Toolbox, Email Scheduler allows you to chedule messages to be sent at specific date/times or intervals by setting up a task for each message. MAPILab Toolbox is a set of 18 different add-ins for Outlook.
Schedule Recurring Email schedules email to send later. The maximum number of emails that can be scheduled can be in the hundreds. You can schedule emails that go out hourly, daily, monthly, early, or randomly. The monthly and yearly patterns can be adjusted by a number of days so that schedules like "2nd to last workday of the year" or "3 days after the first Tuesday of every month" can be specified. Works with all Outlook accounts, including IMAP and Outlook.com.
Use ScheduledSend for Outlook to send emails on a schedule. Set a schedule and recurrence as Outlook appointment and send emails on a later date. The add-in adds a separate calendar where all your scheduled emails are displayed in a familiar fashion.
SendLater is a free Outlook add-in e-mail scheduler with recurring email option. Prepare all your email notifications and reminders in advance and schedule their delivery. Re-send email automatically if a reply is not received. Set up repetitive follow-up emails at comprehensive time intervals. When sending recurrent emails, you can set path to CSV file and load recipients from that CSV file automatically. Send recurrent "Daily" and "Weekly" emails on custom times. Emails will be sent even when Outlook is not running.
OL98: How to Create a Recurring E-mail Message