Hi everyone,
I am using a solution from this web thread as I want to create a button that creates an email in outlook.
https://www.mrexcel.com/board/thread...utlook.969051/
I have got it working perfectly. however as I want the email to come FROM another group mailbox I want to know if it is possible to do this? I have tried adding in the line about FROM after the body text instructions as in this example here - however I get runtime error 438 'Object doesn't support this property or method'
Does this mean adding in the FROM field is not an option?
[Sub Emailtest()
Dim olApp As Outlook.Application
Dim olEmail As Outlook.MailItem
Set olApp = New Outlook.Application
Set olEmail = olApp.CreateItem(olMailItem)
With olEmail
.BodyFormat = olFormatHTML
.Display
.HTMLBody = "UPDATE GOES HERE" & "<br>" & .HTMLBody
.From = "email address goes here"
.To = "email address goes here"
.CC = ""
.Subject = "Enter Subject text here"
end sub]
Bookmarks