Scheduling a recurring email using VBA

Xandler · #1 07-31-2017, 07:17 AM

Okay, I'm using Outlook 2016 and I want to schedule a recurring e-mail to go out to a GROUP and not individual email addresses, but for some reason it will only deliver it to a single e-mail address (as I've tested multiple times already this morning), I'm wondering how I can edit the VBA code to make it send it to the group or more than 1 email address. The code I'm using is one I found off a tutorial on how to do the this so it may be wrong but it is as follows:

Code:

Private Sub Application_Reminder(ByVal Item As Object)
  Dim MItem As MailItem
  Set MItem = Application.CreateItem(olMailItem)
If Item.MessageClass <> "IPM.Appointment" Then Exit Sub
If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub
  MItem.To = Item.Location
  MItem.Subject = Item.Subject
  MItem.Body = Item.Body
  MItem.Send
  Set MItem = Nothing
End Sub

Any help to solve this conundrum I'm having would be appreciated!

The link to the tutorial I found can be located here: https://www.extendoffice.com/documen...ing-email.html

Xandler · #2 08-01-2017, 07:37 AM

Figured it out, had nothing to do with the code, my macro settings for outlook weren't set up correctly. Still need to test if it works for sending to groups though!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Scheduling question	mayachen1@gmail.com	Project	4	05-06-2017 03:32 PM
Nurse Scheduling Help	nishatian1	Excel	3	12-01-2015 02:22 PM
Scheduling of Tasks	asmith1977	Project	0	01-27-2011 11:13 AM
Scheduling of presentations	browe	PowerPoint	0	12-14-2010 06:02 PM
Meeting scheduling - what rooms are available	jgerrish	Outlook	0	02-12-2010 02:35 PM