AutoMacroGuru
New Member
- Joined
- Aug 19, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello,
I am currently trying to send automatic emails in an excel workbook, but every time an email is sent, since my company is subject to TITUS classification, I have to manually select it in a pop up.
I use a regular outlook protocol to send emails
I have not been able to find anything to have the classification automatically selected. It would always be internal. There must be a solution but I don’t know where to look anymore.
Please find below a model of the code used to send the email.
Thanks, waiting for ANY insight :/
AutoMacroGuru
I am currently trying to send automatic emails in an excel workbook, but every time an email is sent, since my company is subject to TITUS classification, I have to manually select it in a pop up.
I use a regular outlook protocol to send emails
I have not been able to find anything to have the classification automatically selected. It would always be internal. There must be a solution but I don’t know where to look anymore.
Please find below a model of the code used to send the email.
VBA Code:
Sub MailOutlook()
Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")
Dim objEmail As Object
Set objEmail = objOutlook.CreateItem(olMailItem)
With objEmail
.To = "someone@somewhere.se"
.Subject = "This is the subject"
.Body = "This is the body of the email"
.Send
End With
End Sub
Thanks, waiting for ANY insight :/
AutoMacroGuru