HOW TO INSERT A SUBMIT FORM BUTTON IN EXCEL THAT SENDS COMPLETED FORM AS AN EMAIL ATTACHMENT // So you have created a fillable form and now you want to make it easy for your users to send their completed forms back to you. You can accomplish this by including a “Submit” button which is essentially a command button you can insert at the bottom of your form so when the user clicks it, it will automatically open their MS Outlook email client and have an email with your return email address, subject and body text with the completed form attached, so that all they have to do is click “Send.”
✅ Link to purchase the MS Excel Employee Engagement Form template with programmed "Submit" button: https://www.etsy.com/listing/94075411...
Here is the VBA code used in this video to create the macro for the Submit command button (be sure to replace the Subject, Body Text and Email address with your own information):
Private Sub CommandButton1_Click()
Dim xOutlookObj As Object
Dim xOutApp As Object
Dim xOutMail As Object
Dim xMailBody As String
On Error Resume Next
Set xOutApp = CreateObject("Outlook.Application")
Set xOutMail = xOutApp.CreateItem(0)
xMailBody = "Type the body or your email message here" & vbNewLine & vbNewLine & _
"Use this if you want a separate line of text" & vbNewLine & _
"Use this if you want another separate line of text"
On Error Resume Next
With xOutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "Enter the Email Subject Here"
.Body = xMailBody
.Attachments.Add ActiveWorkbook.FullName
.Display 'or use .Send
End With
On Error GoTo 0
Set xOutMail = Nothing
Set xOutApp = Nothing
End Sub
__________
**BE SURE TO WATCH HOW TO CREATE FILLABLE FORMS IN EXCEL: • How to Create Fillable Forms in Excel...
** BE SURE TO WATCH HOW TO HIDE THE SUBMIT BUTTON IN EXCEL WHEN PRINTING: • How To Hide Command Button in Excel W...
__________
RESOURCES & GEAR
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ Live Stream Tool: https://amzn.to/2VFJyID
✦ JotForm: https://www.jotform.com/pricing/?utm_...
✦ PresenterMedia: https://shareasale.com/r.cfm?b=417324...
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgibin/webscr.... Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharo... to signup for my email list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
__________
KEYWORDS: #MSExcel, microsoft excel tutorial, create fillable forms, fillin forms, macros, Add a Submit Button to a Form, Create a Submit Form Button in Excel, How to Submit Excel Form to Email, Add a Command Button in Excel, Apply a button to send email with current excel form attached, excel productivity tools, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: • How To Create A Fillable Form In Micr...
➤PowerPoint Tutorials for HR: • PowerPoint Tutorials
➤ Excel Tutorials for HR: • Microsoft Excel Tutorials
➤ Excel Quickies (Around 2 Minutes): • Excel Tips & Tricks
➤ Word Tutorials for HR: • Microsoft Word Tutorials
➤ Welcome | About Me: • Playlist