+ Reply to Thread
Results 1 to 8 of 8

Send Email button with data from Userforms textbox, and comboboxes

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    Pa, usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Send Email button with data from Userforms textbox, and comboboxes

    Hello All, I'm a a novice when it comes to VB, but I'm getting better. I need a little help or if you can help point me in the right direction,it would be greatly appreciated. Google helped a little but I really couldn't find what I'm looking for.

    My issue is that I'm trying to create a userform for an Operator to
    type in

    (Production number)>
    Select (Error type) >
    Type in (M number)>
    Select (AccountManager)>
    Select (employee Assigned)>
    Add (Notes)>
    Click Send Email Button.


    Email button will have data from above in () and sent to selected recipients.

    I will attach the form and hopefully it'll describe things a lot better. Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Send Email button with data from Userforms textbox, and comboboxes

    Be sure to set the reference in Tools->References->Microsoft Outlook Library xx.0
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    03-20-2014
    Location
    Pa, usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Send Email button with data from Userforms textbox, and comboboxes

    Nice!! Thankyou.

    Not enabling Outlook Library explains the error I had, when running it. But other than that it's excactly what I needed, again Many thanks!

  4. #4
    Registered User
    Join Date
    03-20-2014
    Location
    Pa, usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Send Email button with data from Userforms textbox, and comboboxes

    AddMessage$ = "Production Number: " & Me.TxtSoBox & vbCr & _
    "Error Number: " & Me.ComboBox1 & vbCr & _
    "M Number: " & Me.TextBox1 & vbCr & _
    "Notes: " & Me.TextBox2

    Hi, I was trying to separate these lines but its not happy, its just a continuation of the code. I tried vbNewLine, and vbCrLF but nothing happens. Any idea?

  5. #5
    Registered User
    Join Date
    03-20-2014
    Location
    Pa, usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Send Email button with data from Userforms textbox, and comboboxes

    Example

    Production Number:
    Error Number:
    M Number:
    Note:

    But when I ran it, it displayed this.

    Production Number: Error Number: M Number: Note:

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Send Email button with data from Userforms textbox, and comboboxes

    You must be sending it HTML.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 03-25-2014 at 08:16 PM.

  7. #7
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Send Email button with data from Userforms textbox, and comboboxes

    or
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    03-20-2014
    Location
    Pa, usa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Send Email button with data from Userforms textbox, and comboboxes

    Nice, both worked perfectly. Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Send email from address in a textbox
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2013, 05:18 PM
  2. [SOLVED] Command button to transfer multiple data to other sheets, saving in PDF, send email
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-29-2013, 02:03 PM
  3. Using an Option Button to send a textbox value to a cell
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2013, 11:24 PM
  4. [SOLVED] Create CommandButton to send email address maintained in TextBox
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 03:08 PM
  5. send email from button
    By andreww in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2005, 11:05 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