Hi,
I'm new too vba and have lots too learne, but i need some help with my first "project"
I have a userform i want to mail the textbox content from.
The recipients would i like too use a mail adress from a combobox in the same userform and then represent the data in body.
I have tried but i can only send mail with adress in the code not from textbox.
I have 9 textboxes and 2 comboboxes i my userform.
I hope someone can help me.
Dim OLApp As Outlook.Application
Set OLApp = CreateObject("outlook.application")
Dim olMail As Outlook.MailItem
Set olMail = OLApp.CreateItem(olMailItem)
'olMail.To = UserForm1.ComboBox1.Value
olMail.To = "[email protected]"
olMail.Subject = "Subject Line"
olMail.Body = "This is the body of the e-mail"
olMail.Send
Bookmarks