I have a macro that will kick out an email every time an update is saved to a spreadsheet.
Now I need to be able to email multiple people whenever a save is made.
I can get a single To, Cc and BCc to work but if I try to have multiple people addressed or Cc'ed I am having issues.
This is what the code looks like for single recipients......
Any help would be greatly appreciated.
Thanks
On Error Resume Next
With OutMail
.To = "[email protected]"
.CC = "[email protected]"
.BCc = "****[email protected]"
.Subject = "Project Tracker has been recently updated"
.Body = strbody
.Send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Bookmarks