Results 1 to 11 of 11

Mail from userform in excel, content from textboxs and combobox

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2013
    Location
    Sarpsborg, Norway
    MS-Off Ver
    Excel 2013
    Posts
    2

    Mail from userform in excel, content from textboxs and combobox

    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
    Last edited by Fotis1991; 11-26-2013 at 08:58 AM. Reason: pls use code tags around your codes

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Userform ComboBox: Content of ComboBox based off of Conditional Statement
    By Brianandstewie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2013, 03:00 PM
  2. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  3. Populating textboxs with resultsof combobox choice
    By Lensmeister in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 10:27 AM
  4. Looping through userform textboxs to make them visible
    By Alan Steele in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2012, 02:19 PM
  5. help looping through textboxs on userform
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2006, 06:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1