View Single Post
 
Old 07-31-2017, 07:17 AM
Xandler Xandler is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2017
Posts: 2
Xandler is on a distinguished road
Default Scheduling a recurring email using VBA

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
Reply With Quote