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
07-31-2017, 07:17 AM
Scheduling a recurring email using VBA
Similar Threads
Nurse Scheduling Help
Windows 10 
Office 2016
Threaded Mode