Okebiz Video Search



Title:How To Insert A Submit Form Button In Excel - Submit Form to Email – Create Fillable Forms in Excel
Duration:07:15
Viewed:16,128
Published:12-01-2021
Source:Youtube

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 e-mail 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 = "sharon@sharonsmithhr.com"
.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: https://youtu.be/_g7863PjNns

** BE SURE TO WATCH HOW TO HIDE THE SUBMIT BUTTON IN EXCEL WHEN PRINTING: https://youtu.be/04p9UzT4uQQ
__________
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/cgi-bin/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 sign-up for my e-mail 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: https://www.linkedin.com/in/sharonsmi...
Twitter: https://twitter.com/SharonSmithHR
__________
KEYWORDS: #MSExcel, microsoft excel tutorial, create fillable forms, fill-in 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: https://www.youtube.com/watch?v=YktZ3...

➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list...

➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list...

➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list...

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list...

➤ Welcome | About Me: https://www.youtube.com/playlist?list...

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide) How to Create a Data Entry Form in Excel With A...
25:36 | 787,654
How to Create Fillable Forms in Excel - Employee Engagement Survey Template How to Create Fillable Forms in Excel - Employe...
28:25 | 141,695
How to Create Macros in Excel Tutorial How to Create Macros in Excel Tutorial
09:17 | 548,584
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial Fully Automated Data Entry User Form in Excel -...
35:41 | 895,217
Insert a Submit Form Button in Word - Submit Form to Email - Fillable Forms In Word Series Insert a Submit Form Button in Word - Submit Fo...
05:24 | 33,243
Fully Dynamic Emails from Excel with a SINGLE FORMULA! Fully Dynamic Emails from Excel with a SINGLE F...
08:53 | 807,201
Idiot-Proof Forms in Excel - Part 1 - Formatting Idiot-Proof Forms in Excel - Part 1 - Formatting
11:17 | 93,188
SUPER EASY Excel Data Entry Form (NO VBA) SUPER EASY Excel Data Entry Form (NO VBA)
06:22 | 336,485

shopee ads

coinpayu