I am currently trying to send outlook emails with votes via a back end way but am currently stumped. Would appreciate any advice or methods on ways of achieving this.
I am aware of methods utilising front end but would much prefer back end if possible.
Or Create a Macro like Below
and Execute this code using Invoke code activity
Public Sub CreateVotingMessage()
Dim objMsg As MailItem
Set objMsg = Application.CreateItem(olMailItem)
With objMsg
.Subject = âWhatâs for lunch?â
.VotingOptions = âMexican;Italian;Fast Food;Chineseâ
.Importance = olImportanceHigh
.ExpiryTime = DateAdd(âdâ, 3, Now) '3 days from now
.Display
End With
Set objMsg = Nothing
End Sub
But my requirement is I need to call objMsg.Send() outside Invoke Code activity, something using Invoke Method. How can I do it ? I tried to implement but it says "MailItem does not have a public method name âSendâ matching the parameter types, generic arguements.