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