How to create a fillable form with a submit button in Word

preview_player
Показать описание
​In this tutorial you’ll learn how to create a fillable form with a submit button in Word. I've included the visual basic script in the description below so you can use it during that step.

SOFTWARE:

GEAR:

LET’S CONNECT:

NOTE: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue making videos like this. Thank you for your support!

****VISUAL BASIC CODE FOR SUBMIT BUTTON***

Be sure to change the .subject, .body and .to so it will work for you.

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 = "Test Email"

.Body = "This is a test email for submit button"

.Importance = olImportanceNormal

.Attachments.Add xDoc.FullName

.Display

End With

Set xDoc = Nothing

Set xEmail = Nothing

Set xOutlookObj = Nothing

Application.ScreenUpdating = True

End Sub
Рекомендации по теме
Комментарии
Автор

Loved the video. Once the form is made, do you email it to your person to fill it out as an attachment and then they open it, fill it out and hit the submit button and it comes back to you?

primetimeofnebraska
Автор

Thank you for this tutorial! I've watched a few and by far I have liked this one the most. I found that the pace in which you spoke and the tone of your voice made it easy to understand. The visual turotial was also easy to follow. Now, I will go put it to the test! I've now subscribed and I will look forward to you being my 'Go to' for such tutorials. Thank you!

stephanieannmassewilliams
Автор

Superb! PLEASE continue to make these types of tutorials. You are great at it!!!!

dr.c.c.
Автор

This was AWESOME! Concise, well paced, on point with the explanations of the functions and what to expect when activating the buttons. Most of all thank you for the Visual Basic Script! I am building new client forms for my Travel Agency. Just a suggestion to change the background from a black to maybe a grey. Questions will these forms launch if someone opens them on their cell phone to complete? I will also test from my end. THANK

cynthiakerford
Автор

This is a great tutorial. Thanks so much. When I test the submit button myself, Outlook loads just fine to send the form. When I send the form to someone to complete, when they hit submit, they are prompted to save the document before sending and I would prefer that not happen. Do you know why that would be happening and how to prevent it? Thanks so much!

cyrilrussell
Автор

This was really helpful, thank you! Is there a way around the docM file extension? Our organization blocks them for security reasons. I read somewhere that you could put it in a zip folder. Is there anyway to include that in the visual basic code? So that it would attach the file in a zip folder instead of just the file?

oxnardcollegecurriculum
Автор

This video was extremely helpful. I have watched it numerous times and now have the confidence to move ahead. I could not find the Visual Basic information, however, so I could copy that for my document. Where is the description link to copy the script? Excited about finding your videos for future review.

shelliebesharse
Автор

I found your tutorial very useful. I would like to be able to create a multi page form where some information is carried over from the first page to subsequent pages (I.e. member number and first and last name) without having to enter said information multiple times. Recommendations please.

MsMRBEER
Автор

Thank you for this tutorial! It's saving me big time. In the VBA, is there a way to add spaces for the body of the default email? I have a standard message that should go with all forms, but it requires a little paragraph break.

jbmyerov
Автор

Awesome video, really helped me understand how to modify fillable forms with active submit button. Thank you.

simondou
Автор

Great tutorial. If I want to the "submit" to email more than one person, do I need two lines of script for email, or is there a way to write more than one email address into the ".To" line?

scottquinn
Автор

Great video, easy to understand and follow like all your videos. The VBA works well with one email, but what do i do if i was sending to multiple email addresses or CC's

jabarwocky
Автор

This is absolutely fantastic. I've been struggling with Acrobat's equivalent form capability for THREE days. Before giving up trying to send a form to all our family reunion attendees, I found your AWESOME tutorial! Thank you so much. PS. Although I've already successfully tested it, I'd like to use a link that gives you a reward. Which one do I use?

remorrey
Автор

Hi Melissa, thank you for this video tutorial. However, I would like to ask you how do I share the form with customers so they can complete it at their end and when they are done, it comes back to me in a word or PDF format? Also, can I insert E-signature functionality? Your response will be highly appreciated.

godfreyoyasotie
Автор

That was highly informative. Great job. Thank you Melissa.

theadventuresofembrunguy
Автор

Hey Melissa, thank you for this tutorial, I found it very helpful. Everything works however, once the form is submitted it save the filled form and override the blank form. Is there a way in which people can submit the form but it reverts the a blank form for next time?

ramyamohan
Автор

Hi Melissa.
This was a very helpful tutorial.
I HAVE JUST ONE QUESTION : How to export the filled details in online excelsheet or google form? - as I don't want to email it further but to save the details as an excelsheet.

आदर्श-ठघ
Автор

Thank you for the tutorial! It was super helpful and easy to follow!

jessie_marreel
Автор

You are a brilliant teacher. God bless you for this. It has helped me a great deal.😘😘👏👏👌

ritaadams
Автор

Thank you for this awesome explanation. As always there is just one thing. Editing restrictions will not let me select any other options other than read only. I'm not in design mode. I think I followed your instructions. Haw can I fix this?

bepicky
join shbcf.ru