+ Reply to Thread
Results 1 to 3 of 3

Send Excel Userform Data to Outlook Email

  1. #1
    Registered User
    Join Date
    07-27-2017
    Location
    NC,USA
    MS-Off Ver
    2010
    Posts
    6

    Send Excel Userform Data to Outlook Email

    Removed for privacy reasons.
    Last edited by kaemerso; 10-30-2017 at 03:13 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Send Excel Userform Data to Outlook Email

    olmail.Body = "Please see Feedback from Drawing/PL Submittal:" & vbCrLf & vbCrLf & Me.ComboBox1.Value & vbCrLf & Me.ComboBox2.Value & vbCrLf & Me.ComboBox3.Value & vbCrLf & Me.TextBox1.Value & vbclrf & Me.TextBox2.Value & vbCrLf & Me.ComboBox4.Value & vbCrLf & Me.ComboBox5.Value & vbCrLf & Me.TextBox3.Value & vbCrLf
    It looks like you're only specifying values (from ComboBoxes and Text Boxes) ... without seeing your form it's hard to say but as you've used default names there aren't any there called Label1, Label2 etc. I would expect something like:
    Please Login or Register  to view this content.
    With the Label1, 2, 3 etc being whatever you have called your labels.

    Hope that helps. MM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

  3. #3
    Registered User
    Join Date
    07-27-2017
    Location
    NC,USA
    MS-Off Ver
    2010
    Posts
    6

    Re: Send Excel Userform Data to Outlook Email

    Perfect! Thank you so much!

+ 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. Change color of a specific line when using userform to send an email using outlook.
    By Cruzin4Life in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2016, 01:25 PM
  2. Send an Outlook email from Excel
    By maya2ph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2015, 09:29 PM
  3. Send Userform Data via Outlook Email
    By dan.jones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 06:33 AM
  4. Send data table from Excel to outlook as Email
    By praky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 04:31 PM
  5. Outlook send email from data in column from excel spreadsheet
    By benasalisbury in forum Outlook Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2012, 02:24 AM
  6. Send email from Excel to Outlook
    By shaukat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2011, 04:46 PM
  7. Send an email with excel VBA through outlook
    By Alicita in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-10-2011, 05:03 PM

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