I am sending an email via late binding through an Excel template. I have added voting buttons to the template and it works fine. I would like to be able to route the email to different recipients if the user has a voting button response does not select "Approved". Is there a way to program the email coming from Excel to have voting options associated with how the user responds to the voting buttons?
With OutMail
.To = "bossemailaddress"
.CC = ""
.BCC = ""
.Subject = "~TEST~ email”
.HTMLBody = RangetoHTML(rng)
.votingoptions = "Approved; More Info Needed"
'///// HELP NEEDED HERE /////
If .votingresponse = "Approved" Then
.ReplyRecipients.Add (originalemailreceipient)
Else
.ReplyRecipients.Add (originalemailreceipient)
.ReplyRecipients.Add (Newemailreceipient)
End If
'/////
.Send
.Delivery = True
End With
Bookmarks