Загрузка страницы

Insert a Submit Form Button in Word - Submit Form to Email - Fillable Forms In Word Series

HOW TO INSERT A SUBMIT FORM BUTTON IN WORD THAT SENDS COMPLETED FORMS 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.”

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 xEmail As Object
Dim xDoc As Document
Application.ScreenUpdating = False
Set xOutlookObj = CreateObject("Outlook.Application")
Set xEmail = xOutlookObj.CreateItem(olMailItem)
Set xDoc = ActiveDocument
xDoc.Save
With xEmail
.Subject = "Include your own Subject"
.Body = "Include your own verbiage for email body text."
.To = "youremailaddress@youremail.com"
.Importance = olImportanceNormal
.Attachments.Add xDoc.FullName
.Display
End With
Set xDoc = Nothing
Set xEmail = Nothing
Set xOutlookObj = Nothing
Application.ScreenUpdating = True
End Sub

__________
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 1: https://youtu.be/YktZ3B-tyqs
**BE SURE TO WATCH FILLABLE FORMS VIDEO PART 2: https://youtu.be/n_Ni_fj-158

TIP: To ensure the Developer tab is visible in MS Word so you can insert form fields, follow these steps:
1) Right Click on the Ribbon area and select "Customize Ribbon"
2) The Customize Ribbon and Keyboard Shortcuts window opens
3) On the right hand side under "Customize the Ribbon - Main Tab" ensure the "Developer" checkbox is selected, then click OK.
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload 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/sharonsmithhr

Twitter: https://twitter.com/SharonSmithHR
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. 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!
__________
RESOURCES:
✦ JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog

I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=

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!
__________
KEYWORDS: #MSWord, microsoft word tutorial, create fillable forms, fill-in forms, macros, Add a Submit Button to a Form, Create a Submit Form Button in Word, How to Submit Word Form to Email, Add a Command Button in Word, Apply a button to send email with current word form attached, enable developer tab, word productivity tools, Sharon Smith HR, @SharonSmithHR

__________
PLAYLISTS:
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

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

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

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

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

Видео Insert a Submit Form Button in Word - Submit Form to Email - Fillable Forms In Word Series канала Sharon Smith
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
17 июня 2020 г. 0:05:09
00:05:24
Яндекс.Метрика